PostgreSQL display all tables in different schema without setting search_path

Question

recently I experience on postgresql and found that \dt are not show all tables if those tables with the same name but under different schema.

example

test2.my_table1
test1.my_table1

if setting search_path, \dt will only showing the tables which inside the 1st priority schema.

this will be an very pain full to multi-tenant database management.

Does this answer your question? PostgreSQL: Show tables in PostgreSQL — Adrian Klaver
– Adrian Klaver, Commented Jul 16, 2021 at 16:02

Liang Faan · Accepted Answer · 2021-07-16 15:35:00Z

0

simple use command

\dt *.<tale_prefix>*

example:

\dt *.my_*

answered Jul 16, 2021 at 15:35

Liang Faan

312 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1