pg_lo_truncate — Truncate a large object, changing its size
pg_lo_truncateconn
descriptor
length
pg_lo_truncate
changes the size of a large object
to a specified number of bytes. If the new size is smaller than the
current size, the large object is truncated. If the new size is larger
than the current size, the large object is padded with null bytes.
conn
The handle of the connection.
descriptor
A descriptor for the large object from pg_lo_open.
length
The desired new size in bytes for the large object.
All large object manipulation must take place within an SQL transaction block.
This command was added in pgtclng-1.7.0 and in pgintcl-3.1.0.
This command uses or emulates the PostgreSQL
libpq
function lo_truncate
.
That function was added to libpq and the PostgreSQL server in version
8.3, and the command will not be available if using older versions.