2 -- PostgreSQL code for LargeObjects
4 -- $Id: lo.sql.in,v 1.6 2000/11/21 21:51:58 tgl Exp $
7 -- Create the data type
10 -- used by the lo type, it takes an oid and returns an lo object
11 create function lo_in(opaque)
16 -- used by the lo type, it returns the oid of the object
17 create function lo_out(opaque)
22 -- finally the type itself
25 externallength = variable,
30 -- this returns the oid associated with a lo object
31 create function lo_oid(lo)
36 -- same function, named to allow it to be used as a type coercion, eg:
37 -- create table a (image lo);
38 -- select image::oid from a;
40 create function oid(lo)
42 as 'MODULE_PATHNAME', 'lo_oid'
45 -- this allows us to convert an oid to a managed lo object
46 -- ie: insert into test values (lo_import('/fullpath/file')::lo);
47 create function lo(oid)
52 -- This is used in triggers
53 create function lo_manage()