Skip to content

Instantly share code, notes, and snippets.

@rubyandcoffee

rubyandcoffee/terminal

Last active February 3, 2018 13:47
Show Gist options
  • Save rubyandcoffee/e8ae23f3c9b7e38b091ba8748ff88bbe to your computer and use it in GitHub Desktop.
Save rubyandcoffee/e8ae23f3c9b7e38b091ba8748ff88bbe to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Commands
Raw
terminal
# connect to postgres
psql postgres
# list databases
\list
# connect to database
\connect database_name
# show tables
\dt;
# show columns
\d column_name
# quit postgres
\q
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment