@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
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