> > 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 >
Whoops, spoke too soon. I believe it's actually the relfilenode value that you want. Craig >
