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;