On Mon, Jul 21, 2014 at 2:14 PM, Braunstein, Alan <alan_braunst...@mentor.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers