On Sun, 2009-01-11 at 15:33 -0600, Tim Hart wrote: > tjhart=# set search_path to foo, public; > SET > tjhart=# \d > List of relations > Schema | Name | Type | Owner > --------+-----------+-------+-------- > foo | bar_table | table | tjhart > foo | foo_table | table | tjhart > (2 rows) > > tjhart=# set search_path to public, foo; > SET > tjhart=# \d > List of relations > Schema | Name | Type | Owner > --------+-----------+-------+-------- > foo | bar_table | table | tjhart > public | foo_table | table | tjhart > (2 rows) This behavior seems consistent to me. If you type an unqualified name like: SELECT * FROM foo_table; You'll get the one from the first namespace listed in search_path. It makes sense for "\d" to display only the tables that can be seen without specifying a fully-qualified name. Regards, Jeff Davis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
