ALTER LARGE OBJECT
change the definition of a large object
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- anchor
- SQL-ALTERLARGEOBJECT
- file
- sql-alterlargeobject.html
- lang
- en
- name
- ALTER LARGE OBJECT
- purpose
- change the definition of a large object
- purpose zh
- 更改一个大对象的定义
- sections same as
- Unknown
- slug
- 18
- synopsis html
- ALTER LARGE OBJECT <em class="replaceable"><code>large_object_oid</code></em> OWNER TO { <em class="replaceable"><code>new_owner</code></em> | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
- synopsis text
- ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
Syntax
ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }Syntax diagrams
Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.
Definition PG 18
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_oidOID of the large object to be altered
new_ownerThe new owner of the large object
Compatibility
There is no ALTER LARGE OBJECT statement in the SQL standard.
See Also
Chapter 33Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:66b975e3b63bec697a09ad30b0749edb5fa0c5ad1041f6210699ddd4bc8f72d6
Text language: en · wiki-repair-20261023:66b975e3b63bec697a09ad30b0749edb5fa0c5ad1041f6210699ddd4bc8f72d6