PostgreSQL Reference Resources

Official Documentation

• PostgreSQL Official Documentation
• PostgreSQL Tutorial
• pgAdmin Documentation

Online Tutorials

• PostgreSQL Tutorial Website
• SQL Tutorial
• Mode SQL Tutorial

Books

• "PostgreSQL: Up and Running" by Regina Obe
• "The Art of PostgreSQL" by Dimitri Fontaine
• "PostgreSQL High Performance" by Ibrar Ahmed

Tools

• pgAdmin: https://www.pgadmin.org/ - Official GUI tool
• DBeaver: https://dbeaver.io/ - Universal database tool
• DataGrip: https://www.jetbrains.com/datagrip/ - IDE for databases
• psql: Command-line client

Community

• PostgreSQL Mailing Lists
• Stack Overflow - PostgreSQL
• Reddit - r/postgresql
• PostgreSQL Wiki

Extensions

• PostGIS: https://postgis.net/ - Spatial database
• pg_cron: https://github.com/citusdata/pg_cron - Job scheduling
• pg_partman: https://github.com/pgpartman/pg_partman - Partitioning
• TimescaleDB: https://www.timescale.com/ - Time-series

Cheat Sheets

• PostgreSQL Cheat Sheet: https://www.postgresqltutorial.com/postgresql-cheat-sheet/
• SQL Cheat Sheet: https://www.sqltutorial.org/sql-cheat-sheet/