Hi all,

I'm being asked to extract data from a single partitioned table, and pg_dump is acting a little weird. If I enter:

pg_dump -Fc -t "capacity_metering*" > cap_mtr.sql

pg_dump will extract all 34 million records from all of the partition tables, but if I specify:

pg_dump -Fc -t capacity_metering_1400198400 > single_part.sql

with or without quotations and this is one of the partition tables, pg_dump complains that there are no matching tables found. Weirdly enough, if I enter something like "select count(*) on capacity_metering_1400198400" in psql, it works fine. Is it possible to easily dump a single partition table in any manner?