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
]
Sent: Thursday, July 24, 2014 7:31 AM
To: Braunstein, Alan
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Exporting Table-Specified BLOBs Only?
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
Fundamental issue:
PostgreSQL is different than Oracle in how it stores BLOBs
http://www.postgresql.org/docs/9.1/static/catalog-pg-largeobject.html.
In PostgreSQL ...
In the particular tables BLOBS are stored as OID's (unique numbers).
There is one table for all BLOB data (see pg_largeobject