Re: [GENERAL] Get data type aliases

2013-06-13 Thread Rebecca Clarke
That's great, thank you! worked like a charm. On Wed, Jun 12, 2013 at 8:31 PM, Alvaro Herrera 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 varch

Re: [GENERAL] Get data type aliases

2013-06-12 Thread Alvaro Herrera
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 t