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.
