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