Re: How to convert ByteA to Large Objects

Sam Mason <sam@xxxxxxxxxxxxx> · Fri, 23 Jan 2009 14:58:01 +0000

On Fri, Jan 23, 2009 at 12:08:02PM +0000, Howard Cole wrote:
> Is there some nice SQL I can use to convert a BYTEA field into large 
> objects?

You may be able to do something like:

  SELECT oid, lowrite(lo_open(oid, 131072), (SELECT byteafield FROM tbl WHERE x)
  FROM lo_create(NULL) o(oid);

You could turn this around to maybe do:

  UPDATE tbl t SET newoid = (
    SELECT oid FROM (
      SELECT oid, lowrite(lo_open(oid, 131072), t.byteafield)
      FROM lo_create(0) o(oid)) x);

-- 
  Sam  http://samason.me.uk/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general