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. -- Peter Eisentraut http://developer.postgresql.org/~petere/