Re: Simplfied Bytea input/output?

On Wed, 4 Aug 2004, Jerry LeVan wrote:

> 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';
> 

Doing this kind of file/read write is only useful if the client and server 
are on the same machine which is a kind of limiting restriction if you are 
trying to make a generic data browsing tool.  Further any function that 
does file access like this must run with superuser permissions to prevent 
misuse which is another serious restriction.

Kris Jurka