Select Code to Download

CREATE TABLE image {
    item_id    INTEGER NOT NULL,
...
    CONSTRAINT image_pk PRIMARY KEY(item_id),
    CONSTRAINT image_item_id_fk FOREIGN KEY(item_id) REFERENCES item(i
+tem_id)
};

INSERT INTO image VALUES (3, lo_import('/tmp/image_name.jpg'));
SELECT lo_export(picture, '/tmp/image_name.jpg') FROM image WHERE item
+_id = 3;
to delete:
SELECT lo_unlink(picture) FROM image WHERE item_id = 3;