Re: a very naive question about table names in Postgres
Dave Cramer <davecramer@postgres.rocks>
From: Dave Cramer <davecramer@postgres.rocks>
To: Paul Jungwirth <pj@illuminatedcomputing.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2022-01-01T11:48:04Z
Lists: pgsql-general
On Fri, 31 Dec 2021 at 16:25, Paul Jungwirth <pj@illuminatedcomputing.com> wrote: > On 12/31/21 12:27 PM, Martin Mueller wrote: > > 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. > > > > Where is that mapping and how can I query it? On what page of the > > documentation do I find the answer? > > Dear Prof. Mueller, > > Everything you ever wanted to know is here PostgreSQL: Documentation: 14: Chapter 52. System Catalogs <https://www.postgresql.org/docs/14/catalogs.html> Enjoy the journey Dave