Re: listing relations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: listing relations
Дата
Msg-id 17973.1244751254@sss.pgh.pa.us
обсуждение исходный текст
Ответ на listing relations  (Brandon Metcalf <brandon@geronimoalloys.com>)
Ответы Re: listing relations  (Brandon Metcalf <brandon@geronimoalloys.com>)
Список pgsql-general
Brandon Metcalf <brandon@geronimoalloys.com> writes:
> Something interesting I've noticed.  If I have a table by the same
> name in two different schemas, say public and foo, and my search path
> is set to 'public, foo', \d without an argument lists only the one in
> public.

That's intentional.  It's designed to show the same table you'd get if
you did "select * from tabname".  You can do "\d *.tabname" if you want
to see all tables named tabname regardless of schema.

            regards, tom lane

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

Предыдущее
От: Russ Brown
Дата:
Сообщение: Re: When to use cascading deletes?
Следующее
От: "James B. Byrne"
Дата:
Сообщение: search for partial dates