How to determine which tables are created from inheritance.

Поиск
Список
Период
Сортировка
От Chris Barnes
Тема How to determine which tables are created from inheritance.
Дата
Msg-id BLU149-W63CF18B16F7219FB4AA647D4980@phx.gbl
обсуждение исходный текст
Ответы Re: How to determine which tables are created from inheritance.  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
Список pgsql-general

I am using londiste and would like to add tables for partitioned tables only. I.E. exclude the parent.

I am currently using the select below.
What postgres catalog table would I query to see this information?

psql database -t -c "select schemaname||'.'||relname from pg_stat_user_tables where relname like 'tablename%'"|xargs londiste.py londiste.ini provider add

 
Thanks,

Chris

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

Предыдущее
От:
Дата:
Сообщение: good exception handling archiecutre
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Compression on SSL links?