ALTER_LARGE_OBJECT(7pg13)

💖 NAME 💖

ALTER_LARGE_OBJECT — change the definition of a large object

okay bestie, welcome to the ALTER LARGE OBJECT(7) page — this is the glow-up manual for changing a large object’s definition ✨

🎀 SYNOPSIS 🎀

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

🌸 DESCRIPTION 🌸

ALTER LARGE OBJECT changes the definition of a large object. iconic behavior, honestly 💅

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, both rules are always in the group chat here 🫶

🦋 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. literally not in the standard’s group chat 💀

🌈 SEE ALSO 🌈

Chapter 34

that’s the whole vibe, bestie 🎀 from the PostgreSQL 13.23 documentation, dated 2025, page ALTER LARGE OBJECT(7) 💜