Hi, guys,
In the database theory each table is identified as "schema_name"."table_name".
When I tried to look at how to get the table id inside the PostgreSQL,
I saw that I needed to look at the pg_class table.
SELECT oid FROM pg_class WHERE relname = "table_name";
However that query will give a non-unique table id (see the first sentence).
So how do I get the table id based on the "schema_name.table_name"?
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?
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 = ?;
from my ODBC based program, but it returns 0 rows on SQLFetch.
I know PostgreSQL does not use '?' for query parameters
but I thought that since its an ODBC everything should work.
Nevertheless, all bindings were successful, but now rows are returned.
Is this query correct?
Thank you.