> -----Original Message----- > From: Peter Eisentraut [mailto:peter_e@xxxxxxx] > Sent: 17 April 2006 20:16 > To: pgsql-general@xxxxxxxxxxxxxx > Cc: Dave Page; Tony Caduto; chris smith; Zahir Lalani > Subject: Re: [GENERAL] the integer type > > 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. It's not at all unrelated - it just means that none of us were aware of the existance of format_type. Regards, Dave.