Chapters

1. Getting started with PostgreSQL
2. Data Types
3. Dates, Timestamps, and Intervals
4. Table Creation
5. SELECT
6. Find String Length / Character Length
7. COALESCE
8. INSERT
9. UPDATE
10. JSON Support
11. Aggregate Functions
12. Common Table Expressions (WITH)
13. Window Functions
14. Recursive queries
15. Programming with PL/pgSQL
16. Inheritance
17. Export PostgreSQL database table header and data to CSV file
18. Triggers and Trigger Functions
19. Event Triggers
20. Role Management
21. Postgres cryptographic functions
22. Comments in PostgreSQL
23. Backup and Restore
24. Backup script for a production DB
25. Accessing Data Programmatically
26. Connect to PostgreSQL from Java
27. PostgreSQL High Availability
28. EXTENSION dblink and postgres_fdw
29. Postgres Tip and Tricks

https://cdn.shopify.com/s/files/1/0298/0039/8988/files/PostgreSQLNotesForProfessionals.pdf?848