Copy large object data to a client file

The following example uses the lobs table created in Insert an lld_locator row into a table. The lld_toclient function in Copy large object data to a client file copies large object data to the output.txt client file. This function returns t when the function succeeds. The SELECT statement returns t, or true, indicating that the function returned successfully.

-- Copy an lld_locator to a client file
select lld_toclient (lo, 'output.txt') from lobs where key = 2;

(expression) 

           t