Re: a very naive question about table names in Postgres

Поиск
Список
Период
Сортировка
От Craig McIlwee
Тема Re: a very naive question about table names in Postgres
Дата
Msg-id CAGqBcTbuxtyBp8JKasjMPyiDPzLqAe1Ovokmk6aZ+e12TisQ7Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: a very naive question about table names in Postgres  (Craig McIlwee <craigm@vt.edu>)
Список 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.


Craig

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

Craig

В списке pgsql-general по дате отправления:

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: a very naive question about table names in Postgres
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: a very naive question about table names in Postgres