Re: Re: pg_dump and LOs (another proposal)

At 18:15 7/07/00 +0200, Peter Eisentraut wrote:
>Philip Warner writes:
>
>> >psql has \lo_import.
>
>> This is true, but if there are 30000 blobs on an archive tape, I cant dump
>> them into /tmp and wait for the user to run the script. At the current time
>> pg_restore just sends a script to a file or stdout - it has no guarantee of
>> when a \lo_import command will be run, so dumping blobs into the same file
>> between lo_import calls would not be appropriate, since I am in effect
>> requiring a psql attachment.
>
>I don't understand. How else would you restore a large object if not using
>libpq's lo_import() call?
>

Direct connection to DB and use lo_creat, lo_open, lo_write & lo_close -
ie. what lo_import does under the hood.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/