Postgres Pro
Downloads
Home   >   mailing lists

Re: interperting type oid in C code - Mailing list pgsql-general

From Melvin Davidson
Subject Re: interperting type oid in C code
Date
Msg-id CANu8FixGQGxhum1vdV80qx6+EVqS17XCD0+HsFoo7cYyb0e6ow@mail.gmail.com
Whole thread Raw
In response to interperting type oid in C code  (Ken Been <kbbeen@gmail.com>)
Responses Re: interperting type oid in C code  (Ken Been <kbbeen@gmail.com>)
List pgsql-general
Tree view
SELECT typname
   FROM pg_type
 WHERE oid = Oid_x;

On Mon, Oct 19, 2015 at 2:36 PM, Ken Been <kbbeen@gmail.com> wrote:
I'm working on a foreign data wrapper and I want to switch based on the column type.  Specifically, if the column type in the external table is the same as in the (locally defined) foreign table then I can get some speedup for some types.

Through the ForeignScanState object I can get TupleDesc and AttInMetadata opjects, and through there I can get the Oid of the column type, but now I'm stumped.  How can I programmatically check whether Oid X refers to type int4, or whatever?

Thanks.



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Ken Been
Date:
Subject: interperting type oid in C code
Next
From: Ken Been
Date:
Subject: Re: interperting type oid in C code