Debian Codegraph @

doc/src/sgml/ref/alter_large_object.sgml

raw
1 <!--
2 doc/src/sgml/ref/alter_large_object.sgml
3 PostgreSQL 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>
24 ALTER LARGE OBJECT <replaceable class="parameter">large_object_oid</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_ROLE | 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 able to <literal>SET ROLE</literal> to
39 the new owning role.
40 (However, a superuser can alter any large object anyway.)
41 Currently, the only functionality is to assign a new owner, so both
42 restrictions always apply.
43 </para>
44 </refsect1>
45
46 <refsect1>
47 <title>Parameters</title>
48
49 <variablelist>
50 <varlistentry>
51 <term><replaceable>large_object_oid</replaceable></term>
52 <listitem>
53 <para>
54 OID of the large object to be altered
55 </para>
56 </listitem>
57 </varlistentry>
58
59 <varlistentry>
60 <term><replaceable>new_owner</replaceable></term>
61 <listitem>
62 <para>
63 The new owner of the large object
64 </para>
65 </listitem>
66 </varlistentry>
67 </variablelist>
68 </refsect1>
69
70 <refsect1>
71 <title>Compatibility</title>
72
73 <para>
74 There is no <command>ALTER LARGE OBJECT</command> statement in the SQL
75 standard.
76 </para>
77 </refsect1>
78
79 <refsect1>
80 <title>See Also</title>
81
82 <simplelist type="inline">
83 <member><xref linkend="largeobjects"/></member>
84 </simplelist>
85 </refsect1>
86
87 </refentry>