Skip to content

Instantly share code, notes, and snippets.

@tjaart9
tjaart9 / postgres-cheatsheet.md
Created May 30, 2016 08:36 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*