\dD Bug??
Is this a known bug? I created a database (test) and two schemas (s1 and s2)
each of which have one table (s1.test and s2.test) but when I use \dD I see
no schemas listed:
test=# select * from s1.test;
x
-----------------
I am in s1.test
(1 row)
test=# select * from s2.test;
x
-----------------
I am in s2.test
(1 row)
test=# \dD
List of domains
Schema | Name | Type | Modifier
--------+------+------+----------
(0 rows)
Cheers,
Steve
Steve Crawford <scrawford@pinpointresearch.com> writes:
Is this a known bug? I created a database (test) and two schemas (s1 and s2)
each of which have one table (s1.test and s2.test) but when I use \dD I see
no schemas listed:
\dD is for domains, not schemas. There isn't a \d command for schemas
in 7.3.
regards, tom lane
Oops, my mistake.
-Steve
Show quoted text
On Friday 13 December 2002 10:16 am, Tom Lane wrote:
Steve Crawford <scrawford@pinpointresearch.com> writes:
Is this a known bug? I created a database (test) and two schemas (s1 and
s2) each of which have one table (s1.test and s2.test) but when I use \dD
I see no schemas listed:\dD is for domains, not schemas. There isn't a \d command for schemas
in 7.3.regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)