pg_lo_tell — Return the current seek position of a large object, using 64-bit offsets


pg_lo_tell64 conn descriptor


pg_lo_tell64 returns the current read/write position in bytes from the beginning of the large object. The return value is a 64-bit integer, allowing for larger size objects compare to pg_lo_tell.



The handle of the connection.


A descriptor for the large object from pg_lo_open.

Return Value

The current zero-based byte offset in the large object, as a 64-bit integer, suitable for use with pg_lo_lseek64.

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_tell64. Support for 64-bit large object offsets was added to PostgreSQL-9.3.0. In order for pg_lo_tell64 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.