1<!--
2doc/src/sgml/ref/alter_large_object.sgml
3PostgreSQL documentation
4-->
5
6<refentry id="sql-alterlargeobject">
7 <indexterm zone="sql-alterlargeobject">
8  <primary>ALTER LARGE OBJECT</primary>
9 </indexterm>
10
11 <refmeta>
12  <refentrytitle>ALTER LARGE OBJECT</refentrytitle>
13  <manvolnum>7</manvolnum>
14  <refmiscinfo>SQL - Language Statements</refmiscinfo>
15 </refmeta>
16
17 <refnamediv>
18  <refname>ALTER LARGE OBJECT</refname>
19  <refpurpose>change the definition of a large object</refpurpose>
20 </refnamediv>
21
22 <refsynopsisdiv>
23<synopsis>
24ALTER LARGE OBJECT <replaceable class="parameter">large_object_oid</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER }
25</synopsis>
26 </refsynopsisdiv>
27
28 <refsect1>
29  <title>Description</title>
30
31  <para>
32   <command>ALTER LARGE OBJECT</command> changes the definition of a
33   large object.
34  </para>
35
36  <para>
37   You must own the large object to use <command>ALTER LARGE OBJECT</command>.
38   To alter the owner, you must also be a direct or indirect member of the new
39   owning role.  (However, a superuser can alter any large object anyway.)
40   Currently, the only functionality is to assign a new owner, so both
41   restrictions always apply.
42  </para>
43 </refsect1>
44
45 <refsect1>
46  <title>Parameters</title>
47
48  <variablelist>
49   <varlistentry>
50    <term><replaceable>large_object_oid</replaceable></term>
51    <listitem>
52     <para>
53      OID of the large object to be altered
54     </para>
55    </listitem>
56   </varlistentry>
57
58   <varlistentry>
59    <term><replaceable>new_owner</replaceable></term>
60    <listitem>
61     <para>
62      The new owner of the large object
63     </para>
64    </listitem>
65   </varlistentry>
66  </variablelist>
67 </refsect1>
68
69 <refsect1>
70  <title>Compatibility</title>
71
72  <para>
73   There is no <command>ALTER LARGE OBJECT</command> statement in the SQL
74   standard.
75  </para>
76 </refsect1>
77
78 <refsect1>
79  <title>See Also</title>
80
81  <simplelist type="inline">
82   <member><xref linkend="largeobjects"/></member>
83  </simplelist>
84 </refsect1>
85
86</refentry>
87