Re: a very naive question about table names in Postgres

Поиск
Список
Период
Сортировка
От Paul Jungwirth
Тема Re: a very naive question about table names in Postgres
Дата
Msg-id a1a7da95-2091-e1fe-3154-238aeb5964a9@illuminatedcomputing.com
обсуждение исходный текст
Ответ на a very naive question about table names in Postgres  (Martin Mueller <martinmueller@northwestern.edu>)
Ответы Re: a very naive question about table names in Postgres  (Dave Cramer <davecramer@postgres.rocks>)
Список pgsql-general
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,

This question strikes Postgres people a bit like your teenager asking 
where you keep the tallest ladder. There aren't many practical uses for 
accessing these files directly, and if you do it's likely to break your 
database. Could you speak a bit more about your goal here? Perhaps 
someone can suggest a good way to achieve it.

Yours,

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com



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

Предыдущее
От: Josef Šimánek
Дата:
Сообщение: Re: a very naive question about table names in Postgres
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: a very naive question about table names in Postgres