On Mon, Jul 18, 2022 at 8:11 PM Igor Korot <ikoro...@gmail.com> wrote:
> > There is a pg_namespace table - is this where the schema should come from? > If yes - how? > Looking at that table I don't see any unique fields... > Or is this something that is hidden? > Catalogs don't have all of the same metadata that user-space tables have. "namespace" is the historical and internally used label for what we present to users as "schema" > > In fact I'm trying to run following query: > > SELECT c.oid FROM pg_class c, pg_namespace nc WHERE nc.oid = > c.relnamespace AND c.relname = ? AND nc.nspname = ?; > Then either relname or nspname caused the records to filter out because the join part of that where clause is correct. I suggest you experiment using psql and literals so you can provide both actual queries and results more easily. The whole self-contained script thing is very helpful. You can also learn quite a bit by echoing queries in psql then using the various description metacommands that query these same catalogs - thus echoing the queries psql itself uses to answer this same question. David J.
