Fundamental issue:
PostgreSQL is different than Oracle in how it stores BLOBs

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 
Catalogs/PostgreSQL/pg_largeobject in pgadmin tree). It stores colums 
"OID/pageno/actual binary data (page)".

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>

I have four tables containing BLOBs I want to export w/o the BLOB data - that's 
What I also want is the remaining 200+ tables exported with THEIR BLOB entries, 
if any, but NOT one BLOB from the four tables explicitly not specified in 
pg_dump command; so JUST the BLOBs associated to any of the 200+ tables I do 


Reply via email to