postgres=# psql -U postgres -h 127.0.0.1 -p 5432 -d dreamstart_dev -w
postgres-# d
No relations found.
postgres-# c dreamstart_dev
psql (9.2.18, server 9.5.6)
WARNING: psql version 9.2, server version 9.5.
Some psql features might not work.
You are now connected to database "dreamstart_dev" as user "postgres".
dreamstart_dev-# d
List of relations
Schema | Name | Type | Owner
--------+-----------------------+----------+------------
public | dream_category | table | dreamstart
public | dream_category_id_seq | sequence | dreamstart
public | dream_comment | table | dreamstart
public | dream_comment_id_seq | sequence | dreamstart
public | dream_post | table | dreamstart
public | dream_post_id_seq | sequence | dreamstart
public | dream_user | table | dreamstart
public | dream_user_id_seq | sequence | dreamstart
(8 rows)