How to list domains

[Alexander Cohen]

How can i get list of all domains available?

thanks!

--
Alexander Cohen
http://www.toomuchspace.com
[phone]
[phone]
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Bruce Momjian]

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
pg***@candle.ph a.pa.us | [phone]
+ 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

[Alexander Cohen]

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
[phone]
[phone]
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
pg***@candle.ph a.pa.us | [phone]
+ 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

[Bruce Momjian]

Alexander Cohen wrote:

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?

They are SQL-standard names for our int4, float8 types. They map
internally to those types. I don't know a way to list separately.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Tom Lane]

Bruce Momjian <pg***@candle.p ha.pa.us> writes:

They are SQL-standard names for our int4, float8 types. They map
internally to those types. I don't know a way to list separately.

You can use format_type() to get the canonical per-spec form. For instance

regression=# select typname, format_type(oid ,-1) from pg_type where oid in (1043,23);
typname | format_type
---------+-------------------
varchar | character varying
int4 | integer
(2 rows)

I don't know of any way to get a listing of secondary aliases that the
parser will recognize (such as "int" for int4). They're hardwired into
the grammar rather than being table entries anywhere. Fortunately,
there are not all that many beyond the typname and the format_type forms.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly