Re: Unexpected behavior from psql

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