Re: interperting type oid in C code

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