Re: exporting/importing BLOB's (lo_* style)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: exporting/importing BLOB's (lo_* style)
Дата
Msg-id 15646.1221249243@sss.pgh.pa.us
обсуждение исходный текст
Ответ на exporting/importing BLOB's (lo_* style)  (kevin kempter <kevin@kevinkempterllc.com>)
Список 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 по дате отправления:

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