zirosas
7/4/2013 - 11:16 PM

Postgresql command

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