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