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 CAGqBcTbuxtyBp8JKasjMPyiDPzLqAe1Ovokmk6aZ+e12TisQ7Q@mail.gmail.com
Whole thread Raw
In response to 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

Whoops, spoke too soon.  I believe it's actually the relfilenode value that you want.

Craig

pgsql-general by date:

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