Tools
PostgreSQL Cheat Sheet
Print-ready cheat sheet for PostgreSQL, organized for fast lookup, study, and desk-side use
Sample
What's in this cheat sheet
- Connecting
- Tables & Schemas
- Data Types
- Queries
- Joins & Subqueries
- Indexes
- Functions & Procedures
- Roles & Permissions
- JSON Support
- Common Patterns
Command Line
psql -U postgres
psql -h localhost -p 5432 -U user -d mydb
psql "postgresql://user:pass@host:5432/mydb"
psql Meta-Commands
\l | List databases |
\c dbname | Connect to database |
\dt | List tables |
\d tablename | Describe table structure |
\dn | List schemas |
\du | List roles |
\q | Quit psql |
\i file.sql | Execute SQL file |
Download the full cheat sheet for all sections, formatted for print
Download PDFDownloads
Choose the treatment that matches how you read
-
Recommended
Standard
B&W, ink-efficient. The default for laser printers and photocopies
Best for Printouts and desk-side reference
-
Color
Warm color accents for on-screen reading or color printers
Best for Screen reading or color printers
-
Reference Card
Maximum density, 4-column layout. Everything on one page
Best for Fast scanning and minimum paper use
