Development tools
Essential tools and techniques for PostgreSQL developers.
Guides by category​
psql​
Master the PostgreSQL command-line interface.
- How to use variables in psql scripts - 5 min (advanced)
- Learn how to work with schema metadata by spying after psql - 5 min (advanced)
- psql tuning - 5 min (intermediate)
- psql shortcuts - 5 min (beginner)
- How to plot graphs right in psql on macOS (iTerm2) - 5 min (beginner)
- How to make "\e" work in psql on a new machine - 5 min (beginner)
- How to format text output in psql scripts - 5 min (beginner)
SQL techniques​
Advanced SQL patterns and best practices.
- How to import CSV to Postgres - 7 min (intermediate)
- "Find-or-insert" using a single query - 5 min (beginner)
- How to format SQL (SQL style guide) - 6 min (beginner)
- How to generate fake data - 5 min (beginner)
- How to use lib_pgquery in shell to normalize and match queries from various sources - 5 min (beginner)
Client tools​
Work effectively with PostgreSQL client applications.
- How to change ownership of all objects in a database - 5 min
- How to use Docker to run Postgres - 5 min (beginner)
- How to set application_name without extra queries - 5 min