How to select a schema in postgres when using psql?
In PostgreSQL the system determines which table is meant by following a search path, which is a list of schemas to look in.
The first matching table in the search path is taken to be the one wanted, otherwise, if there is no match a error is raised, even if matching table names exist in other schemas in the database.
To show the current search path you can use the following command:
SHOW search_path;And to put the new schema in the path, you could use:
SET search_path TO myschema;Or if you want multiple schemas:
SET search_path TO myschema, public;Reference: https://www.postgresql.org/docs/current/static/ddl-schemas.html
\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'.
Do you want to change database?
\l - to display databases\c - connect to new databaseUpdate.
I've read again your question.To display schemas
\dn - list of schemasTo change schema, you can try
SET search_path TO