PostgreSQL Commands Cheat Sheet
Free interactive PostgreSQL commands cheat sheet with 120+ entries across 10 categories. Search, filter, and copy SQL commands instantly. Covers psql Meta-Commands (\l, \c, \dt, \d, \di, \dv, \du, \df, \dn, \dp, \timing, \x), Database & Schema DDL (CREATE/DROP DATABASE, CREATE/ALTER/DROP TABLE, CREATE SCHEMA, CREATE INDEX, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SEQUENCE, TRUNCATE, COMMENT ON), Querying & Filtering (SELECT, WHERE, ORDER BY, LIMIT/OFFSET, DISTINCT/DISTINCT ON, BETWEEN, IN/NOT IN, LIKE/ILIKE, IS NULL, CASE, COALESCE, NULLIF), JOINs & Subqueries (INNER JOIN, LEFT/RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN, LATERAL JOIN, NATURAL JOIN, self-join, EXISTS/NOT EXISTS, ANY/ALL, UNION/INTERSECT/EXCEPT, WITH CTE, WITH RECURSIVE), Aggregation & Window Functions (COUNT/SUM/AVG, MIN/MAX, GROUP BY, HAVING, string_agg, array_agg, ROW_NUMBER, RANK/DENSE_RANK, LAG/LEAD, FIRST_VALUE/LAST_VALUE, NTILE, PARTITION BY + window frames), Data Types & Functions (integer/bigint/serial/numeric, text/varchar/char, boolean, date/timestamp/timestamptz, json/jsonb, array, enum, uuid, generate_series, string functions, date functions, ::type casting), Indexes & Performance (CREATE INDEX, UNIQUE INDEX, INDEX CONCURRENTLY, partial index, expression index, multicolumn index, GIN, GiST, BRIN, EXPLAIN, EXPLAIN ANALYZE, pg_stat_user_indexes), Transactions & Concurrency (BEGIN/COMMIT/ROLLBACK, SAVEPOINT, isolation levels, SELECT FOR UPDATE, LOCK TABLE, NOWAIT/SKIP LOCKED, deadlock detection, advisory locks, VACUUM, ANALYZE, MVCC, REINDEX), User & Permissions (CREATE ROLE, CREATE USER, GRANT, REVOKE, ALTER ROLE, ALTER DEFAULT PRIVILEGES, RLS, CREATE POLICY, pg_roles, SET ROLE, REASSIGN OWNED/DROP OWNED), and Backup & Admin (pg_dump, pg_dumpall, pg_restore, psql -f, COPY, pg_stat_activity, pg_locks, pg_stat_database, CHECKPOINT, ALTER SYSTEM, SHOW/current_setting, pg_terminate_backend). The PostgreSQL Relational Core aesthetic โ deep void black #060b10 background with subtle hex page-block grid overlay (48px), B-tree index branching node pattern in background, 40 floating data packet particles (blue/cyan), cool blue ambient core glow, dark reactor panel cards rgba(10,15,22,0.94) with category-colored left borders and copper rivet corner details. Rajdhani display headings (bold, uppercase), Fira Code body text, JetBrains Mono code. Pulsating green core indicator dot after title. Category colors: Electric Blue #4a90d9 (psql), PostgreSQL Navy #336791 (DDL), Cyan #33cccc (Queries), Copper #c97d3b (JOINs), Amber #e0a030 (Window), Violet #9966cc (Data Types), Green #4ae54a (Indexes), Red #e05555 (Transactions), Steel #8899aa (Permissions), Gold #ddaa44 (Backup). Card hover: translateY(-3px) with cool blue box-shadow glow. 100% client-side, no signup.