Postgresql – connect to schema

Connect to database:

psql -U postgres

Play with the following commands:

\l - Display database
\c - Connect to database
\dn - List schemas
\dt - List tables inside public schemas
\dt schema1. - List tables inside particular schemas. For eg: 'schema1'.