ALTER_LARGE_OBJECT(7pg16)

🌟 ALTER_LARGE_OBJECT: PostgreSQL 16.15 Documentation, section 7 🌟

Okay bestie, welcome to ALTER LARGE OBJECT — aka the ALTER_LARGE_OBJECT page from the PostgreSQL 16.15 Documentation. Section 7 is serving main-character energy today, and we're gonna make large-object ownership make sense. 🫶

✨ NAME ✨

ALTER_LARGE_OBJECT - change the definition of a large object. That's the whole assignment, and it ate. 💅

🎀 SYNOPSIS 🎀

ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

💖 DESCRIPTION 💖

Okay so ALTER LARGE OBJECT changes the definition of a large object. Lowkey iconic. ✨

You must own the large object to use ALTER LARGE OBJECT. To alter the owner, you must also be able to SET ROLE to the new owning role. (But ngl, a superuser can alter any large object anyway.) Currently, the only functionality is to assign a new owner, so both restrictions always apply — periodt. 💅

🫶 PARAMETERS 🫶

• large_object_oid — OID of the large object to be altered
• new_owner — The new owner of the large object

🌈 COMPATIBILITY 🌈

There is no ALTER LARGE OBJECT statement in the SQL standard — not a single one, bestie. 😭

👑 SEE ALSO 👑

Chapter 35 — go read it, bestie. Iykyk. 🦋

💖 That's the tea from PostgreSQL 16.15, dated 2026 — manual page out, bestie. 🎀