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

From Albe Laurenz
Subject Re: interperting type oid in C code
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50FBC59F@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: interperting type oid in C code  (Ken Been <kbbeen@gmail.com>)
List pgsql-general
Ken Been 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, but I actually wanted to do it from C code.  But anyway I think I found the answer: use the
> symbolic constants in catalog/pg_type.h, such as INT4OID.

That's fine, there is no problem with doing that.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Birta Levente
Date:
Subject: RAID and SSD configuration question
Next
From: Nicolas Paris
Date:
Subject: Re: PSQL Tools