Re: listing relations - Mailing list pgsql-general

From Tom Lane
Subject Re: listing relations
Date
Msg-id 17973.1244751254@sss.pgh.pa.us
Whole thread Raw
In response to listing relations  (Brandon Metcalf <brandon@geronimoalloys.com>)
Responses Re: listing relations
List 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 by date:

Previous
From: Russ Brown
Date:
Subject: Re: When to use cascading deletes?
Next
From: "James B. Byrne"
Date:
Subject: search for partial dates