Internally pg_dump have capability to filter the table data to dump by same filter clause but it have no interface to use it and the patch here [1] adds interface to it but it have at-least two issue, one is error message in case of incorrect where clause specification is somehow hard to debug and strange to pg_dump .Other issue is it applies the same filter clause to multiple tables if pattern matching return multiple tables and it seems undesired behavior to me because mostly we don’t want to applied the same where clause specification to multiple table. The attached patch contain a fix for both issue