Re: How to list domains

[Alexander Cohen <alex@toomuchspace.com>]

Yes, i just discovered that. Thanks! Actually im trying to display in 
an app of mine a list of all types to the user. That goes fine but i 
noticed that that list does not have "integer", "double precision" and 
simple type names like that. I thought they would be domains. But i 
guess they are not. Where can i find these types? What are they?

--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443


On Apr 7, 2004, at 2:47 PM, Bruce Momjian wrote:

> Alexander Cohen wrote:
> > How can i get list of all domains available?
>
> Using psql, domains are listed with \dD.  They also appear in \dT.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 
> 19073
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend