\d tablename # view table
\dt # show all tables
\q # exit psql console
\du # show all users
\l # show all databases
\conninfo # get connection info