listing relations

From: Brandon Metcalf <brandon(at)geronimoalloys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: listing relations
Date: 2009-06-11 20:06:20
Message-ID: Pine.LNX.4.58L.0906111500040.11099@cedar.geronimoalloys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

I see why from the SQL that \d generates, but just wondering why \d
doesn't generate SQL to list both.

--
Brandon

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Russ Brown 2009-06-11 20:10:34 Re: When to use cascading deletes?
Previous Message Joshua D. Drake 2009-06-11 19:36:07 Re: [sfpug] "Rails and PostgreSQL" now up on media.postgresql.org