Postgres Pro
Downloads
Home   >   mailing lists

Postgres C-API: How to get the Oid for a custom type defined in a schema outside of the current search path - Mailing list pgsql-general

From Michael Krüger
Subject Postgres C-API: How to get the Oid for a custom type defined in a schema outside of the current search path
Date
Msg-id AA1EBC9D-74F0-4AA6-8035-692A010A17EB@kruegers.email
Whole thread Raw
Responses Re: Postgres C-API: How to get the Oid for a custom type defined in a schema outside of the current search path
List pgsql-general
Tree view
Dear all,

I need to find out the Oid of a custom type in C programming language. This type is defined in a schema, outside of the standard search path, e.g. public.
I know that I can call TypenameGetTypid to find out an Oid. But this is not working for me if the type is not in the public namespace.
How can I query a non-public Oid? Do I have to change the search path? If yes how do I do it? As mentioned I need to do this with the C interface. 

Regards,
Michael

pgsql-general by date:

Previous
From: charles meng
Date:
Subject: Alter the column data type of the large data volume table.
Next
From: Pavel Stehule
Date:
Subject: Re: Postgres C-API: How to get the Oid for a custom type defined in a schema outside of the current search path