Thread: Get data type aliases
Hi all.
I have a function that has an attribute with datatype of character varying. In the pg_type table the oid of the data type points to type varchar
Is there somewhere that identifies the alias for each type?
E.g.
int4 = integer
varchar = character varying.
and so on.
I can do an if statement in my code but I'd prefer not to.
Thanks in advance.
Rebecca
Rebecca Clarke escribió: > Hi all. > > I have a function that has an attribute with datatype of character varying. > In the pg_type table the oid of the data type points to type varchar > > Is there somewhere that identifies the alias for each type? Cast the type name to regtype. That outputs the "official" name. alvherre=# select 'int'::regtype; regtype --------- integer (1 fila) -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
That's great, thank you! worked like a charm.
On Wed, Jun 12, 2013 at 8:31 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Rebecca Clarke escribió:> Hi all.Cast the type name to regtype. That outputs the "official" name.
>
> I have a function that has an attribute with datatype of character varying.
> In the pg_type table the oid of the data type points to type varchar
>
> Is there somewhere that identifies the alias for each type?
alvherre=# select 'int'::regtype;
regtype
---------
integer
(1 fila)
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services