Skip to content

Instantly share code, notes, and snippets.

View diogonicoleti's full-sized avatar

Diogo Nicoleti diogonicoleti

79 followers · 59 following
  • Itajaí
  • 03:08 (UTC -03:00)
View GitHub Profile
@diogonicoleti
diogonicoleti / postgres-cheatsheet.md
Created June 26, 2017 13:26 — 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 *.*