That's great, thank you! worked like a charm.
On Wed, Jun 12, 2013 at 8:31 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> 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
