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

>