Postgresql 中文操作指南

ALTER LARGE OBJECT

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 更改大型对象的定义。

ALTER LARGE OBJECT changes the definition of a large object.

你必须拥有大型对象才能使用 ALTER LARGE OBJECT 。要更改所有者，你必须还能够 SET ROLE 至新的所有者角色。（但是，超级用户可以更改任何大型对象。）当前，唯一的功能是指定新所有者，因此这两个限制总是适用。

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

SQL 标准中没有 ALTER LARGE OBJECT 语句。

There is no ALTER LARGE OBJECT statement in the SQL standard.

See Also

Chapter 35

Chapter 35