Postgres Pro
Downloads
Home   >   mailing lists

Re: oid data types mapping in libpq functions - Mailing list pgsql-general

From Adrian Klaver
Subject Re: oid data types mapping in libpq functions
Date
Msg-id 201006170714.53315.adrian.klaver@gmail.com
Whole thread Raw
In response to oid data types mapping in libpq functions  (zhong ming wu <mr.z.m.wu@gmail.com>)
List pgsql-general
Tree view 
On Wednesday 16 June 2010 7:42:02 pm zhong ming wu wrote:
> Dear List
>
> Where can I find this mapping of oid to pg data types mentioned in
> libpq documentation?
> Why is such information not mentioned in the documentation?  A general
> knowledge?
>
> Thanks
>
> Mr Wi

I think you are looking for the table pg_type.

SELECT oid,typname from pg_type;

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Leonardo F
Date:
Subject: Re: Given N, finding the interval of N hours with max(sum(..))
Next
From: Merlin Moncure
Date:
Subject: Re: oid data types mapping in libpq functions