Re: listing relations

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