Re: PoC: pg_dump --filter-data (like Oracle Where Clause on RMAN for specific tables)

I've seen this idea pop up over the years, and it's still a good one. Rather than invent new flags, I think a better approach would be to convince pg_dump to dump a view, such that table foo has a view fooslice to limit / filter the output. Then we can simply do:

While we could make the view mapping into a separate filtering file as you suggest, that's more complexity and also a little more dangerous in an action-at-a-distance way, so I'd rather have people be very specific in the mapping on the command line.

I could swear I made a POC years ago for something like this, but it's long gone. If I get some time, I'll give it a fresh attempt.