GeezerVison

The World Wide Web, restored to 800 pixels of glory.

GeezerVison is showing www.postgresql.org — ALTER LARGE OBJECT

October 15, 2026: PostgreSQL 19 RC 1 Released!

Documentation → PostgreSQL 18

Supported Versions: Current (18) / 17 / 16 / 15 / 14

Development Versions: 19 / devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0

ALTER LARGE OBJECT
Prev	Up	SQL Commands	Home	Next

ALTER LARGE OBJECT

ALTER LARGE OBJECT — change the definition of a large object

Synopsis

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

Description

ALTER LARGE OBJECT changes the definition of a large object.

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. (However, a superuser can alter any large object anyway.) Currently, the only functionality is to assign a new owner, so both restrictions always apply.

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.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.