I can't seem to figure out how to back up the large ogjects I have in my
DB.
Here's the situation:
I insert a large object (via PHP) into my DB. I also insert a record
into a table that uses the OID of the LO I inserted. I later expect to
pull the record out of the table, get the OID I stored of the LO, and
then export that object.
The question is: How do I backup the database including the large
objects? pg_dump doesn't seem to help me here. The only way I have
seen to access a large object is teh /lo_export command in psql.
so what is the common usage of large objects?
My main goal is a method of backing up a database that conists of a
table that stores the OID of the large objects, the large objects
themselves, and then restoring all of this to a new DB (whether it's on
the same machine or a different one). MInd you I have to have the
large objects maintain their origianl OID.
Any input appreciated.
Chris
--
"I think your slogan 'Liberty or Death' is splendid, and whichever one
you decide on will be all right with me." - Alexander Woollcott