conect to postgres through psql:

psql -h <host> -U <username> -p <port>

list of users:

\du

list of databases:

\l

choice database:

\c <db-name>

list of tables in current database:

\dt *.*

table informations (columns name and type, indexes, etc):

\d <table-name>