Why does PostgreSQL's \dt show only public schema tables?

user_846910 0
Viewed 37445

I have created a new schema in my PostgreSQl database with psql:

CREATE SCHEMA my_schema;

But when I issue the \dt command, I see only the tables that are in the public schema. However, I can access all the tables in my_schema with my_schema.table_name.

How can I see all the tables from all the schemas in psql?

postgresql
1 Answers
Related