| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org, Zahir Lalani <zahir(at)systemz(dot)net> |
| Subject: | Re: the integer type |
| Date: | 2006-04-17 20:19:14 |
| Message-ID: | 4443F842.9050809@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Eisentraut wrote:
> Dave Page wrote:
>
>>> It's not a error, pgAdmin III simply does not display the
>>> word integer in it's drop down comboboxes, it uses all the
>>> internal representation of types not the SQL standard aliases.
>>>
>> Which allows you to use any custom datatype or domain that you like.
>>
>
> That is completely unrelated. If pgadmin (or any tool) passed the data
> types it presumably fetches from pg_type or thereabouts through the
> format_type function it could present the user with a full list of
> actually available data types but in their preferred spellings.
>
>
Yes, PG Lightning Admin uses the format_type function, though I modify
some of the returned pretty names.
I change "character varying" back to varchar etc.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-04-17 20:20:56 | Re: tsearch partial word |
| Previous Message | Dave Page | 2006-04-17 19:50:34 | Re: the integer type |