Skip to content

Instantly share code, notes, and snippets.

:octocat:
Focusing

Joshua Murithi Murithijoshua

:octocat:
Focusing
Block or report user

Report or block Murithijoshua

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@Murithijoshua
Murithijoshua / postgres-cheatsheet.md
Created Jun 21, 2019 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet
View postgres-cheatsheet.md

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
You can’t perform that action at this time.