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

From Tom Lane
Subject Re: exporting/importing BLOB's (lo_* style)
Date
Msg-id 15646.1221249243@sss.pgh.pa.us
Whole thread Raw
In response to exporting/importing BLOB's (lo_* style)  (kevin kempter <kevin@kevinkempterllc.com>)
List pgsql-admin
kevin kempter <kevin@kevinkempterllc.com> writes:
> 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.

Why don't you just use pg_dump?

            regards, tom lane

pgsql-admin by date:

Previous
From: kevin kempter
Date:
Subject: exporting/importing BLOB's (lo_* style)
Next
From: "Scott Marlowe"
Date:
Subject: Re: Recommend dba maintenance tasks on a regular bases