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
