Thread: \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)