Client: psql

To login with a specific username: psql -U <user>

To login with username and password:

PGPASSWORD=<password> psql -U <user>

(Source)

Show tables: \dt, or \dt+ to include sizing information.