diff options
| author | Tatsuo Ishii <ishii@postgresql.org> | 2008-03-22 01:55:14 +0000 |
|---|---|---|
| committer | Tatsuo Ishii <ishii@postgresql.org> | 2008-03-22 01:55:14 +0000 |
| commit | 325c0a39e45aeefef89c2ef585cdf7577578a416 (patch) | |
| tree | 530e4d13b62f56652040cfda826da4d5ccdce724 /doc/src | |
| parent | bc49703d91ad53cbb5d5d40467e062feb2fd6ac8 (diff) | |
Add server side lo_import(filename, oid) function.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/lobj.sgml | 5 |
1 files changed, 4 insertions, 1 deletions
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 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/lobj.sgml,v 1.47 2008/03/19 00:39:33 ishii Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/lobj.sgml,v 1.48 2008/03/22 01:55:14 ishii Exp $ --> <chapter id="largeObjects"> <title id="largeObjects-title">Large Objects</title> @@ -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'; </programlisting> |