From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | possible psql \d bug in 8.3 beta2 |
Date: | 2007-12-24 03:16:35 |
Message-ID: | 852299.6370.qm@web31812.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-12-24 03:28:29 | Re: possible psql \d bug in 8.3 beta2 |
Previous Message | Richard Broersma Jr | 2007-12-23 23:35:59 | Re: Constraint Trigger's referenced_table |