Seeing tables with the same name on different schemas

Поиск
Список
Период
Сортировка
От Robert Sosinski
Тема Seeing tables with the same name on different schemas
Дата
Msg-id 2433849924454530BB2C3755F1A4526B@ticketevolution.com
обсуждение исходный текст
Ответы Re: Seeing tables with the same name on different schemas  (raghavendra.rao@enterprisedb.com)
Список pgsql-general
Дерево обсуждения
Hey Everyone,

Question, I have multiple schemas on a database, and these schemas sometimes have the tables of the same name.  However, when I do \d to see what tables I have, I only see the first table (based on the order of the search path), but no the other tables that have the same name on different schemas.

Is there a way to see all tables across all schemas?

Thanks,

-- 
Robert Sosinski

В списке pgsql-general по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Need help in reclaiming disk space by deleting the selected records
Следующее
От: raghavendra.rao@enterprisedb.com
Дата:
Сообщение: Re: Seeing tables with the same name on different schemas