Finding out to which table a specific row belongs

Поиск
Список
Период
Сортировка
От Jost Degenhardt
Тема Finding out to which table a specific row belongs
Дата
Msg-id 43A055BF.1030907@web.de
обсуждение исходный текст
Ответы Re: Finding out to which table a specific row belongs  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-sql
Hi there,
I have the following problem: My database consists of several tables 
that are inherited from each other with one single supertable on top of 
that hierarchy. Now I would like to select a single row in that 
supertable and want to find out to which of the tables in the hierarchy 
it belongs. As far as I understand the pg_depend table only shows the 
hierarchy of the tables but does not contain the oids of the actual 
rows. Is there any possibility to solve this problem by using the pg_* 
tables?
I would very much appreciate any help!
Thank you in advance, Jost



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

Предыдущее
От: Gianluca Riccardi
Дата:
Сообщение: Re: DB design and foreign keys
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Finding out to which table a specific row belongs