From 325c0a39e45aeefef89c2ef585cdf7577578a416 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Sat, 22 Mar 2008 01:55:14 +0000 Subject: Add server side lo_import(filename, oid) function. --- doc/src/sgml/lobj.sgml | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/lobj.sgml b/doc/src/sgml/lobj.sgml index 69a21c99cf7..65ac435e36e 100644 --- a/doc/src/sgml/lobj.sgml +++ b/doc/src/sgml/lobj.sgml @@ -1,4 +1,4 @@ - + Large Objects @@ -422,6 +422,9 @@ SELECT lo_unlink(173454); -- deletes large object with OID 173454 INSERT INTO image (name, raster) VALUES ('beautiful image', lo_import('/etc/motd')); +INSERT INTO image (name, raster) -- same as above, but specify OID to use + VALUES ('beautiful image', lo_import('/etc/motd', 68583)); + SELECT lo_export(image.raster, '/tmp/motd') FROM image WHERE name = 'beautiful image'; -- cgit v1.2.3