exporting/importing BLOB's (lo_* style) - Mailing list pgsql-admin

From kevin kempter
Subject exporting/importing BLOB's (lo_* style)
Date
Msg-id 71F52673-AB71-49C1-BC36-A0179CA3D00C@kevinkempterllc.com
Whole thread Raw
Responses Re: exporting/importing BLOB's (lo_* style)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: exporting/importing BLOB's (lo_* style)  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Hi All;

I want to dump a set of BLOB's from one db/server and import to another.

I assume I cannot do a pg_dump unless I also dump related
pg_largeobject rows for the referenced OID

I assume I'll need to export via distinct lo_export commands and use
lo_import to insert into the second database server.

Is there a way to do a bulk transfer or export/import of lo_* style
large objects ?


Thanks in advance

pgsql-admin by date:

Previous
From: Fabricio
Date:
Subject: Re: Recommend dba maintenance tasks on a regular bases
Next
From: Tom Lane
Date:
Subject: Re: exporting/importing BLOB's (lo_* style)