t == t...@sss.pgh.pa.us writes: t> Brandon Metcalf <bran...@geronimoalloys.com> writes: t> > Something interesting I've noticed. If I have a table by the same t> > name in two different schemas, say public and foo, and my search path t> > is set to 'public, foo', \d without an argument lists only the one in t> > public.
t> That's intentional. It's designed to show the same table you'd get if t> you did "select * from tabname". You can do "\d *.tabname" if you want t> to see all tables named tabname regardless of schema. Yeah, I figured there was a reason for the SQL being crafted that way. Is there a "\" command to show all tables in the current search path? -- Brandon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
