I want to list all the Partitions created by dynamic triggers in Postgresql 9.1
I was able to generate a count of partitions for tables which are partitioned using Frank Heikens' answer in http://stackoverflow.com/questions/8634144/get-number-of-partitions-in-postgresql-database
Let me explain, i have a table "foo",i have a insert trigger defined on foo which creates "foo_1" "foo_2",... dynamically.
The partition for insert is chosen based on the primary key id, a range based partitioning.
So is it possible to display all partitions currently in place for the table "foo"?