Re: listing relations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brandon Metcalf <brandon(at)geronimoalloys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: listing relations
Date: 2009-06-11 20:14:14
Message-ID: 17973.1244751254@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brandon Metcalf <brandon(at)geronimoalloys(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James B. Byrne 2009-06-11 20:23:30 search for partial dates
Previous Message Russ Brown 2009-06-11 20:10:34 Re: When to use cascading deletes?