Get data type aliases

From: Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Get data type aliases
Date: 2013-06-12 15:04:31
Message-ID: CAMChtdfJO50+d63CDT+f8+KtVj0aSou2yXOHfMhDe+hsuzy0rQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2013-06-12 15:38:37 Re: Determining the type (array, object, or scalar) of a JSON value
Previous Message Andrew Tipton 2013-06-12 14:02:57 Determining the type (array, object, or scalar) of a JSON value