<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.17 2007/07/0301:30:35 neilc Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/alter_sequence.sgml,v 1.18 2007/10/0316:48:43 tgl Exp $

PostgreSQL documentation

-->

[ MINVALUE <replaceable class="parameter">minvalue</replaceable> | NO MINVALUE ] [ MAXVALUE <replaceable class="parameter">maxvalue</replaceable> | NO MAXVALUE ]

[ RESTART [ WITH ] <replaceable class="parameter">start</replaceable> ] [ CACHE <replaceable class="parameter">cache</replaceable> ] [ [ NO ] CYCLE ]

[ OWNED BY { <replaceable class="parameter">table</replaceable>.<replaceable class="parameter">column</replaceable> | NONE } ]

ALTER SEQUENCE <replaceable class="parameter">name</replaceable> SET SCHEMA <replaceable class="parameter">new_schema</replaceable>

ALTER SEQUENCE <replaceable class="parameter">name</replaceable> RENAME TO <replaceable class="parameter">new_name</replaceable>

ALTER SEQUENCE <replaceable class="parameter">name</replaceable> SET SCHEMA <replaceable class="parameter">new_schema</replaceable>

</synopsis>

</refsynopsisdiv>

</varlistentry>

<varlistentry>

<term><replaceable class="parameter">new_schema</replaceable></term>

<term><replaceable class="parameter">new_name</replaceable></term>

<listitem>

<para>

The newschema for the sequence.

The newname for the sequence.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><replaceable class="parameter">new_name</replaceable></term>

<term><replaceable class="parameter">new_schema</replaceable></term>

<listitem>

<para>

The newname for the sequence.

The newschema for the sequence.

</para>

</listitem>

</varlistentry>

</para>

</refsect1>

<refsect1>

<title>Examples</title>

<para>

Restart a sequence called <literal>serial</literal>, at 105:

<programlisting>

ALTER SEQUENCE serial RESTART WITH 105;

</programlisting>

</para>

</refsect1>

<refsect1>

<title>Notes</title>

same sequence, <command>ALTER SEQUENCE</command>'s effects on the sequence

generation parameters are never rolled back;

those changes take effect immediately and are not reversible. However,

the <literal>OWNED BY</>and <literal>SET SCHEMA</> clauses are ordinary

catalog updatesand can be rolled back.

the <literal>OWNED BY</>, <literal>RENAME</>,and <literal>SET SCHEMA</>

clauses cause ordinarycatalog updatesthat can be rolled back.

</para>

<para>

<para>

Some variants of <command>ALTER TABLE</command> can be used with

sequences as well; for example, to rename a sequenceuse <command>ALTER

TABLE RENAME</command>.

sequences as well; for example, to rename a sequenceit is also

possible to use <command>ALTERTABLE RENAME</command>.

</para>

</refsect1>

<refsect1>

<title>Examples</title>

<para>

Restart a sequence called <literal>serial</literal>, at 105:

<programlisting>

ALTER SEQUENCE serial RESTART WITH 105;

</programlisting>

</para>

</refsect1>

<refsect1>

<title>Compatibility</title>

<para>

<command>ALTER SEQUENCE</command> conforms to the <acronym>SQL</acronym>

standard,

except for the<literal>OWNED BY</> and <literal>SET SCHEMA</literal>

clauses, which are<productname>PostgreSQL</productname> extensions.

standard, except for the <literal>OWNED BY</>, <literal>RENAME</>, and

<literal>SET SCHEMA</literal> clauses, which are

<productname>PostgreSQL</productname> extensions.

</para>

</refsect1>

<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/alter_view.sgml,v 1.2 2007/07/08 17:47:38 tgl Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/alter_view.sgml,v 1.3 2007/10/03 16:48:43 tgl Exp $

PostgreSQL documentation

-->

<title>Description</title>

<para>

<command>ALTER VIEW</command> changes the definition of a

view. To execute this command you must be the owner of the view.

<command>ALTER VIEW</command> changes the definition of a view.

The only currently available functionality is to rename the view.

To execute this command you must be the owner of the view.

</para>

</refsect1>

</variablelist>

</refsect1>

<refsect1>

<title>Notes</title>

<para>

Some variants of <command>ALTER TABLE</command> can be used with

views as well; for example, to rename a view it is also

possible to use <command>ALTER TABLE RENAME</command>. To change

the schema or owner of a view, you currently must use <command>ALTER

TABLE</>.

</para>

</refsect1>

<refsect1>

<title>Examples</title>