ALTER_LARGE_OBJECT(7pg15)

🎀 NAME 🎀

okay bestie, welcome to ALTER_LARGE_OBJECT — the PostgreSQL 15.19 manual page for ALTER LARGE OBJECT(7), and its whole thing is: change the definition of a large object. That's the assignment. That's the vibe. 💅

✨ 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 straightforward, highkey iconic. 💖

You must own the large object to use ALTER LARGE OBJECT. To alter the owner, you must also be a direct or indirect member of the new owning role. (However, a superuser can alter any large object anyway. 👑) Currently, the only functionality is to assign a new owner, so both restrictions always apply. No cap.

🌸 PARAMETERS 🌸

• large_object_oid — OID of the large object to be altered. It's giving "ID tag for the object getting a glow-up" 🏷️.
• new_owner — the new owner of the large object. Handing over the keys, fr fr 🔑.

💀 COMPATIBILITY 💀

There is no ALTER LARGE OBJECT statement in the SQL standard. Not me checking the SQL standard and finding zero crumbs. 🙈

🔥 SEE ALSO 🔥

• Chapter 35 — that's the reference bestie, go read it 📚.

later bestie! This was the ALTER LARGE OBJECT(7) page from PostgreSQL 15.19, dated 2026. Mwah 💋🎀