Brandon Metcalf <bran...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
