Link Search Menu Expand Document

Postgres SQL command line


heroku pg:psql --app my-app-name

You may need certain sofware installed on your local system to make this work.


  • \dt describe tables (list names of tables)
  • select * from users limit 1; show first row in users table
  • select * from users where username='cgaucho'; show one row of the table
  • select * from roster_students,users where username='cgaucho' and roster_students.user_id =; join two tables