Download Markdown
Best for copying commands, snippets, and config into notes, prompts, or docs
Download MarkdownTools
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
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
Text formats
Copy or download as plain text
Preview
The web preview is for quick browsing. The PDF remains the authoritative print artifact
Open in Browser