Обсуждение: \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 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)