Re: the integer type

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, "Tony Caduto" <tony_caduto(at)amsoftwaredesign(dot)com>, "chris smith" <dmagick(at)gmail(dot)com>, "Zahir Lalani" <zahir(at)systemz(dot)net>
Subject: Re: the integer type
Date: 2006-04-17 19:16:10
Message-ID: 200604172116.12149.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-17 19:21:47 Re: plpgsql replication stored procedure
Previous Message Rich Shepard 2006-04-17 17:31:29 Re: Syntax Help Requested