I want to list all the partitions created by dynamic triggers in PostgreSQL 9.1.
I was able to generate a count of partitions using this related answer by Frank Heikens.
I have a table
foo with an insert trigger that creates
foo_2 etc. dynamically. The partition for insert is chosen based on the primary key id, a range based partitioning.
Is it possible to display all partitions currently in place for table