This page in other versions: Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4



pg_lo_write -- write to a large object


pg_lo_write conn descriptor buf len


pg_lo_write writes at most len bytes from a variable buf to a large object.



The handle of a connection to the database in which the large object exists.


A descriptor for the large object from pg_lo_open.


The string to write to the large object (not a variable name, but the value itself).


The maximum number of bytes to write. The number written will be the smaller of this value and the length of the string.

Return Value

The number of bytes actually written is returned; this will ordinarily be the same as the number requested. In event of an error, the return value is negative.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group