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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
