Is seems that \d is missing the following entry
when I set search_path to display two schemas:
List of relations
Schema | Name | Type | Owner
---------+-------------+-------+----------
project | managers | table | teaminst





instrumentation=> select version();
version
--------------------------------------------------------
PostgreSQL 8.3beta2, compiled by Visual C++ build 1400
(1 row)

instrumentation=> set search_path to project;
SET
instrumentation=> \d
List of relations
Schema | Name | Type | Owner
---------+-------------+-------+----------
project | managers | table | teaminst
project | project_tls | table | teaminst
project | projects | table | teaminst
(3 rows)

instrumentation=> set search_path to history;
SET
instrumentation=> \d
List of relations
Schema | Name | Type | Owner
---------+----------+-------+----------
history | managers | table | teaminst
(1 row)

instrumentation=> set search_path to history, project;
SET
instrumentation=> \d
List of relations
Schema | Name | Type | Owner
---------+-------------+-------+----------
history | managers | table | teaminst <--where is project.managers
project | project_tls | table | teaminst
project | projects | table | teaminst
(3 rows)

instrumentation=>

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Richard Broersma Jr <rabroersma@yahoo.com> writes:
> Is seems that \d is missing the following entry
> when I set search_path to display two schemas:
> List of relations
> Schema | Name | Type | Owner
> ---------+-------------+-------+----------
> project | managers | table | teaminst

It's hidden by the "managers" table in the earlier "history" schema.
\d without any particular schema specification will only show tables
that could be accessed by an unqualified table name.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--- On Sun, 12/23/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> > ---------+-------------+-------+----------
> > project | managers | table | teaminst
>
> It's hidden by the "managers" table in the
> earlier "history" schema.
> \d without any particular schema specification will
> only show tables
> that could be accessed by an unqualified table name.


I see. Thanks for the clarification.

Regards,
Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend