Skip to content

Instantly share code, notes, and snippets.

View nimrodshn's full-sized avatar

Nimrod Shneor nimrodshn

View GitHub Profile
@nimrodshn
nimrodshn / postgres-cheatsheet.md
Created July 28, 2017 17: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 *.*