Skip to content

Instantly share code, notes, and snippets.

@smilingleo
smilingleo / postgres-cheatsheet.md
Created June 5, 2017 15:25 — 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 *.*