Brandon Metcalf <brandon@xxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general