copying large objects - Mailing list pgsql-general

From Nigel J. Andrews
Subject copying large objects
Date
Msg-id Pine.LNX.4.21.0303191555030.10824-100000@ponder.fairway2k.co.uk
Whole thread Raw
List pgsql-general

I just had a thought for something I'm doing. Can't I just copy a large object
into a new one by doing something like:

INSERT INTO pg_largeobject
 SELECT anewoid, pageno, data FROM pg_largeobject WHERE oid = srcid

?

How do I get the new oid? There's not a sequence to get the next one is there?


--
Nigel J. Andrews


pgsql-general by date:

Previous
From: Kurt Overberg
Date:
Subject: Re: Big insert/delete memory problems
Next
From: Flower Sun
Date:
Subject: How to get information of active/inactive user connection for postgresql