Postgres Pro
Downloads
Home   >   mailing lists

How to determine which tables are created from inheritance. - Mailing list pgsql-general

From Chris Barnes
Subject How to determine which tables are created from inheritance.
Date
Msg-id BLU149-W63CF18B16F7219FB4AA647D4980@phx.gbl
Whole thread Raw
Responses Re: How to determine which tables are created from inheritance.
List pgsql-general
Tree view

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 by date:

Previous
From:
Date:
Subject: good exception handling archiecutre
Next
From: Bruce Momjian
Date:
Subject: Re: Compression on SSL links?