PostgreSQL Basic commands

connect

psql -h HOST -U USER -d DB

change the password

\password

show database

\l
SELECT datname FROM pg_database;

connect database

\connect thumbnail

list schemas

\dn

list tables in the schema

\dt thumbnail_service.

list all tables

SELECT table_schema,table_name FROM information_schema.tables;

desc table

\d thumbnail_service.thumbnail

vertical result 

\x

quit

\q