pg_lo_truncate64 — Truncate a large object, changing its size, using a 64-bit offset


pg_lo_truncate64 conn descriptor length


pg_lo_truncate64 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. The new size is a 64-bit integer, allowing for larger size objects compare to pg_lo_truncate.



The handle of the connection.


A descriptor for the large object from pg_lo_open.


The desired new size in bytes for the large object, as a 64-bit integer.

Return Value

Nothing. A Tcl error will be thrown if an error occurs.


All large object manipulation must take place within an SQL transaction block.

This command was added in pgtclng-2.1.0 and in pgintcl-3.5.0.

This command uses or emulates the PostgreSQL libpq function lo_truncate64. In order for pg_lo_truncate64 to be available and usable, the library must be be built and linked with PostgreSQL libpq 9.3.0 or higher (does not apply to pgintcl), and be connected to a PostgreSQL server version 9.3.0 or higher. Logo

This version of the manual was produced for the Pgtcl-ng Sourceforge project web service site, which requires the logo on each page.

To download a logo-free copy of the manual, see the Pgtcl-ng project downloads area.