Skip to content

Instantly share code, notes, and snippets.

@edmondchuc

edmondchuc/postgres.md

Last active November 30, 2018 00:36
Show Gist options
  • Save edmondchuc/19cc826c942271671fee02baab47cb37 to your computer and use it in GitHub Desktop.
Save edmondchuc/19cc826c942271671fee02baab47cb37 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL commands. Tags: postgres
Raw
postgres.md

Common PostgreSQL commands

Log in as a user

sudo -u username psql

List databases

\l

Connect to a database

\c databasename

List relations

\d

View stuff in a relation

SELECT * FROM schemaname.relationname

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment