Re: a very naive question about table names in Postgres
Craig McIlwee <craigm@vt.edu>
From: Craig McIlwee <craigm@vt.edu>
To: Martin Mueller <martinmueller@northwestern.edu>
Cc: pgsql-general@lists.postgresql.org
Date: 2021-12-31T20:36:19Z
Lists: pgsql-general
I know that on my Mac the tables are kept in the data directory > /Users/martinmueller/Library/Application Support/Postgres/var-13. If I go > there I see that internally the tables have numbers. Somewhere in the > system there must be a table that maps the name I gave to table X to the > numerical inside the database. > Check the pg_class table in the system catalog. The numeric value is the OID. https://www.postgresql.org/docs/14/catalog-pg-class.html Craig >