[HACKERS] Exporting Table-Specified BLOBs Only?

2014-07-21 Thread Braunstein, Alan
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 under

Re: [HACKERS] Exporting Table-Specified BLOBs Only?

2014-07-24 Thread Braunstein, Alan
@gmail.com] 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 wrote: > What do I need? > > A method of using pg_dump to selectivel