exporting/importing BLOB's (lo_* style)

Поиск
Список
Период
Сортировка
От kevin kempter
Тема exporting/importing BLOB's (lo_* style)
Дата
Msg-id 71F52673-AB71-49C1-BC36-A0179CA3D00C@kevinkempterllc.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Fabricio
Дата:
Сообщение: Re: Recommend dba maintenance tasks on a regular bases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: exporting/importing BLOB's (lo_* style)