Simplfied Bytea input/output?

From: Jerry LeVan <jerry(dot)levan(at)eku(dot)edu>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Simplfied Bytea input/output?
Date: 2004-08-04 15:04:49
Message-ID: A16B3084-E627-11D8-BFBD-000393779D9C@eku.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I am adding image and large object support in my Cocoa
postgresql browser.

Are there going to be any enhanced bytea support functions
coming along?

It seems sorta silly to have to write customized C code
to import a file into a bytea field.

Maybe something like

CREATE TABLE image (
name text,
raster bytea
);

INSERT INTO image (name, raster)
VALUES ('beautiful image', bytea_import('/etc/motd'));

SELECT bytea_export(image.raster, '/tmp/motd') FROM image
WHERE name = 'beautiful image';

Jerry

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2004-08-04 15:17:58 Re: Where are all the users?
Previous Message Dave Cramer 2004-08-04 14:55:36 Re: trash talk