Skip to content

Instantly share code, notes, and snippets.

@zirosas

zirosas/Postgresql command

Last active December 19, 2015 09:09
Show Gist options
  • Save zirosas/5930788 to your computer and use it in GitHub Desktop.
Save zirosas/5930788 to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql command
Raw
Postgresql command
\c db_name : to connect to a certain database
\l : lists all databases
\dt : lists all tables in the current database
\d+ tablename : display table schema
heroku pg:psql : connect to Heroku psql
psql -h localhost : to connect
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment