Re: [pgadmin-support] Exporting Table-Specified BLOBs Only?

2014-07-21 Thread Braunstein, Alan
Is any Developer looking at this issue? From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Braunstein, Alan Sent: Monday, April 28, 2014 1:05 PM To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Exporting Table-Specified BLOBs Only

[pgadmin-support] Exporting Table-Specified BLOBs Only?

2014-04-28 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