Re: Exporting Table-Specified BLOBs Only?

On Mon, Jul 21, 2014 at 2:14 PM, Braunstein, Alan
<alan_braunstein(at)mentor(dot)com> wrote:
> What do I need?
>
> A method of using pg_dump to selectively export BLOBs with OID’s used in the
> tables specified with --table <table_name1> --table <table_name2>

Hmm. If you take a full backup using pg_dump -Fc, you can then use
pg_restore -l and pg_restore -L to find and selectively restore
whatever objects you want; e.g. restore the tables first, then fetch
the list of OIDs from the relevant columns and restore those
particular blobs.

But I don't think we've got a tool built into core for doing this kind
of filtering on the dump side.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company