PG_LO_TELL(n)

💅 pg_lo_tell — bestie edition 💅

okay so this little icon lives in the PostgreSQL Tcl Interface Documentation, and she is here to tell you where you’re at inside a large object. no cap, it’s giving “cursor location check” energy 💖

✨ NAME ✨

pg_lo_tell — return the current seek position of a large object 🎀

🌸 SYNOPSIS 🌸

pg_lo_tell conn descriptor

🦋 DESCRIPTION 🦋

pg_lo_tell returns the current read/write position in bytes from the beginning of the large object. literally just “where are we rn” but for a large object, and yes she ate 💅

🍓 ARGUMENTS 🍓

• conn — the handle of a connection to the database in which the large object exists. bestie, this is your database connection ✨
• descriptor — a descriptor for the large object from pg_lo_open. this is the large-object handle you got from pg_lo_open 🫶

👑 RETURN VALUE 👑

a zero-based offset in bytes suitable for input to pg_lo_lseek. so like, you can take this number and hand it straight to pg_lo_lseek — slay 💜

lowkey important: it’s a zero-based offset in bytes, not vibes. keep it exact, iykyk 🌈

mwah 💖 this iconic little page is from the PostgreSQL Tcl Interface Documentation, dated 17 September 2020 — periodt 🎀✨