Get data type aliases - Mailing list pgsql-general

From Rebecca Clarke
Subject Get data type aliases
Date
Msg-id CAMChtdfJO50+d63CDT+f8+KtVj0aSou2yXOHfMhDe+hsuzy0rQ@mail.gmail.com
Whole thread Raw
Responses Re: Get data type aliases  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
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?

E.g. 
int4 = integer
varchar = character varying.
 and so on.

I can do an if statement in my code but I'd prefer not to.

Thanks in advance.

Rebecca







pgsql-general by date:

Previous
From: Andrew Tipton
Date:
Subject: Determining the type (array, object, or scalar) of a JSON value
Next
From: Merlin Moncure
Date:
Subject: Re: Determining the type (array, object, or scalar) of a JSON value