pg_lo_tell — Return the current seek position of a large object


pg_lo_tell conn descriptor


pg_lo_tell returns the current read/write position in bytes from the beginning of the large object.



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, suitable for use with pg_lo_lseek.

A Tcl error will be thrown if an error occurs.


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

This function is limited to using a 32-bit signed offset (about 2GB). See pg_lo_tell64 for 64-bit offset support.

This command uses or emulates the PostgreSQL libpq function lo_tell. 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.