Postgres Pro
Downloads
Home   >   mailing lists

Re: a very naive question about table names in Postgres - Mailing list pgsql-general

From Craig McIlwee
Subject Re: a very naive question about table names in Postgres
Date
Msg-id CAGqBcTYzFeuRugHA-8xkQ92oU10bLZWkRypLsrjzFC7FeEp9fQ@mail.gmail.com
Whole thread Raw
In response to a very naive question about table names in Postgres  (Martin Mueller <martinmueller@northwestern.edu>)
Responses Re: a very naive question about table names in Postgres  (Craig McIlwee <craigm@vt.edu>)
List pgsql-general
Tree view



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.


Craig

pgsql-general by date:

Previous
From: Martin Mueller
Date:
Subject: a very naive question about table names in Postgres
Next
From: Gavin Flower
Date:
Subject: Re: a very naive question about table names in Postgres