Re: Get data type aliases

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