Re: listing relations

t == tgl@sss.pgh.pa.us writes:

 t> Brandon Metcalf <brandon@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