Hi Patrick
docgen=# CREATE TABLE fotos (name CHAR(15), bild OID);
CREATE
docgen=# INSERT INTO fotos VALUES
docgen-# ('eule',lo_import('/home/conni/eule.gif'));
INSERT 18999 1
docgen=# SELECT * FROM fotos;
name | bild
-------------------+----------
eule | 18999
(1 row)
docgen=# SELECT lo_export(fotos.bild, '/tmp/euleout.gif')
docgen-# FROM fotos WHERE name = 'eule';
lo_export
-----------
1
(1 row)
docgen=# SELECT lo_unlink(fotos.bild) FROM fotos WHERE name = 'eule';
lo_unlink
-----------
1
(1 row)
Regards
Conni
