PG_LO_LSEEK(n)

📦 version 3.1.1, in alpine 3.22, alpine 3.23, alpine 3.24, nixpkgs unstable

✨ NAME ✨

Okay bestie, welcome to the pg_lo_lseek(n) page from the PostgreSQL Tcl Interface Documentation 💅 — this one is all about pg_lo_lseek, the function that lets you seek to a position of a large object. No cap, that's the whole vibe.

✨ SYNOPSIS ✨

pg_lo_lseek conn descriptor offset whence

✨ DESCRIPTION ✨

pg_lo_lseek moves the current read/write position to offset bytes from the position specified by whence. That's it, that's the tea ☕ — it's giving "jump to exactly where you need to be in the large object." 🦋

✨ ARGUMENTS ✨

  • conn — the handle of a connection to the database in which the large object exists. 🫶
  • descriptor — a descriptor for the large object from pg_lo_open. Iconic little handle, honestly.
  • offset — the new seek position in bytes. 📏
  • whence — specified from where to calculate the new seek position: SEEK_CUR (from current position), SEEK_END (from end), or SEEK_SET (from start). ✨
Lowkey important: whence is the one choosing the starting point for the seek math, so keep those three values close. 💖

✨ RETURN VALUE ✨

None. Literally none, bestie — no return value to catch. 💀💅

With love from the PostgreSQL Tcl Interface Documentation, dated 17 September 2020. 🎀✨

📦 where this page comes from