copying large objects

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: copying large objects
Date: 2003-03-19 15:59:45
Message-ID: Pine.LNX.4.21.0303191555030.10824-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Flower Sun 2003-03-19 15:59:47 How to get information of active/inactive user connection for postgresql
Previous Message Kurt Overberg 2003-03-19 15:24:14 Re: Big insert/delete memory problems