Re: Get data type aliases

That's great, thank you! worked like a charm.

On Wed, Jun 12, 2013 at 8:31 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>wrote:

> 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
>