On Fri, 2022-10-14 at 13:39 +0200, Dominique Devienne wrote: > Hi. I'm using binary binds and results for DMLs, as well as for COPY. > > So far, I've stayed within built-in scalar and array types, thus I > could hardcode the OIDs of values "in the type-system" (in C++, via > traits). > But I'd like to venture into extension (e.g. hstore) and custom > (enums, domain, etc...) types. > Thus I'm wondering: > 1) whether "official" extensions have fixed/stable OIDs, like in my > hstore example. If so, where are they defined? > 2) how should I be looking up OIDs for custom (or extension?) types > with libpq? Any specific APIs? Or I need to do SQL instead? > 3) If I duplicate custom types per-schema, to keep them standalone, > they'll get different OIDs, right? You use the #defines like TEXTOID for the built-in Oids, right? For types from an extensions, you would run a query on "pg_type". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
