Thread: copying large objects

copying large objects

From
"Nigel J. Andrews"
Date:

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