</REFSYNOPSISDIVINFO>

<SYNOPSIS>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE>

[*] ADD [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">type</REPLACEABLE>

[ *] ADD [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">type</REPLACEABLE>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE>

[*] RENAME [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> TO <REPLACEABLE CLASS="PARAMETER">newcolumn</REPLACEABLE>

[ *] RENAME [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> TO <REPLACEABLE CLASS="PARAMETER">newcolumn</REPLACEABLE>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE>

RENAME TO <REPLACEABLE CLASS="PARAMETER">newtable</REPLACEABLE>

</SYNOPSIS>

<VARIABLELIST>

<VARLISTENTRY>

<TERM>

<ReturnValue>status</ReturnValue>

<replaceable>status</replaceable>

</TERM>

<LISTITEM>

<PARA>

<VARIABLELIST>

<VARLISTENTRY>

<TERM>

<ReturnValue>ALTER</ReturnValue>

<returnvalue>ALTER</returnvalue>

</TERM>

<LISTITEM>

<PARA>

<VARLISTENTRY>

<TERM>

<ReturnValue>NEW</ReturnValue>

<returnvalue>NEW</returnvalue>

</TERM>

<LISTITEM>

<PARA>

Description

</TITLE>

<PARA>

ALTER TABLE changes the definition of an existing table.

<command>ALTER TABLE</command> changes the definition of an existing table.

The new columns and their types are specified in the same style

and with the the same restrictions as in CREATE TABLE.

and with the the same restrictions as in<command>CREATE TABLE</command>.

The RENAME clause causes the name of a table or column

to change without changing any of the data contained in

the affected table. Thus, the table or column will

<PARA>

The keyword COLUMN is noise and can be omitted.

<PARA>

ALTER TABLE/RENAME is a PostgreSQL language extension.

<PARA>

<Quote>[*]</Quote> following a name of a table indicates that statement

should be run over that table and all tables below it in the

inheritance hierarchy.

Refer toPostgreSQL User's Guidefor further

ThePostgreSQL User's Guidehas further

information on inheritance.

<PARA>

Refer totheCREATE TABLEreferencefor further description

Refer to CREATE TABLE for a further description

of valid arguments.

</REFSECT2>

SQL92

</TITLE>

<PARA>

SQL92 specifies some additional capabilities for ALTER TABLE

statement which are not yet directly supported by <ProductName>Postgres</ProductName>:

<command>ALTER TABLE/RENAME</command>

is a <productname>Postgres</productname> language extension.

<PARA>

SQL92 specifies some additional capabilities for <command>ALTER TABLE</command>

statement which are not yet directly supported by

<ProductName>Postgres</ProductName>:

<VARIABLELIST>

<VARLISTENTRY>

<TERM>

<Synopsis>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> ALTER [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> ALTER [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE>

SET DEFAULT <REPLACEABLE CLASS="PARAMETER">default</REPLACEABLE>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> ALTER [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE>

ADD [CONSTRAINT <REPLACEABLE CLASS="PARAMETER">constraint</REPLACEABLE>] <REPLACEABLE CLASS="PARAMETER">table-constraint</REPLACEABLE>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> ALTER [ COLUMN ] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE>

ADD [ CONSTRAINT <REPLACEABLE CLASS="PARAMETER">constraint</REPLACEABLE> ] <REPLACEABLE CLASS="PARAMETER">table-constraint</REPLACEABLE>

</Synopsis>

</TERM>

<LISTITEM>

<PARA>

Puts the default value or constraint specified into the

definition of column in the table. See CREATE TABLE for the

definition of column in the table.

See <command>CREATE TABLE</command> for the

syntax of the default and table-constraint clauses.

If a default clause already exists, it will be replaced by

the new definition. If any constraints on this column already

<TERM>

<Synopsis>

ALTER TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE>

DROP [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> { RESTRICT | CASCADE }

DROP [COLUMN] <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> { RESTRICT | CASCADE }

</Synopsis>

</TERM>

<LISTITEM>

</PARA>

</VARIABLELIST>

</REFENTRY>

<!--

<REPLACEABLE CLASS="PARAMETER">

</REPLACEABLE>

<ReturnValue></ReturnValue>

<PARA>

</PARA>

<VARIABLELIST>

<VARLISTENTRY>

<TERM>&bull;

</TERM>

<LISTITEM>

<PARA>

</PARA>

</LISTITEM>

</VARLISTENTRY>

</VARIABLELIST>

<PARA>

</PARA>

-->

</REFPURPOSE>

<REFSYNOPSISDIV>

<REFSYNOPSISDIVINFO>

<DATE>1998-04-15</DATE>

<DATE>1998-09-08</DATE>

</REFSYNOPSISDIVINFO>

<synopsis>

ALTER USER <replaceable class="PARAMETER">username</replaceable>

[WITH PASSWORD <replaceable class="PARAMETER">password</replaceable>]

[CREATEDB | NOCREATEDB]

[CREATEUSER | NOCREATEUSER]

[IN GROUP <replaceable class="PARAMETER">groupname</replaceable> [, ...] ]

[VALID UNTIL '<replaceable class="PARAMETER">abstime</replaceable>']

ALTER USER <replaceable class="PARAMETER">username</replaceable>

[WITH PASSWORD <replaceable class="PARAMETER">password</replaceable>]

[CREATEDB | NOCREATEDB]

[CREATEUSER | NOCREATEUSER]

[IN GROUP <replaceable class="PARAMETER">groupname</replaceable> [, ...] ]

[VALID UNTIL '<replaceable class="PARAMETER">abstime</replaceable>']

</synopsis>

<REFSECT2 ID="R2-SQL-ALTERUSER-1">

<REFSECT2INFO>

<DATE>1998-04-15</DATE>

<DATE>1998-09-08</DATE>

</REFSECT2INFO>

<TITLE>

Inputs

</TITLE>

<PARA>

Refer to CREATE USER statement for a detailed description of each

Refer to<command>CREATE USER</command> for a detailed description of each

clause.

</para>

<VARIABLELIST>

</PARA>

</LISTITEM>

</VARLISTENTRY>

<VARLISTENTRY>

<TERM>

<REPLACEABLE CLASS="PARAMETER"> password </REPLACEABLE>

</PARA>

</LISTITEM>

</VARLISTENTRY>

<VARLISTENTRY>

<TERM>

<REPLACEABLE CLASS="PARAMETER"> groupname </REPLACEABLE>

</PARA>

</LISTITEM>

</VARLISTENTRY>

<VARLISTENTRY>

<TERM>

<REPLACEABLE CLASS="PARAMETER"> abstime </REPLACEABLE>

</TERM>

<LISTITEM>

<PARA>

The date (and, optionally, the time) at which this user's access is to be terminated.

The date (and, optionally, the time)

at which this user's access is to be terminated.

</PARA>

</LISTITEM>

</VARLISTENTRY>

<REFSECT2 ID="R2-SQL-ALTERUSER-2">

<REFSECT2INFO>

<DATE>1998-04-15</DATE>

<DATE>1998-09-08</DATE>

</REFSECT2INFO>

<TITLE>

Outputs

<VARIABLELIST>

<VARLISTENTRY>

<TERM>

<ReturnValue>status</ReturnValue>

<replaceable>status</replaceable>

</TERM>

<LISTITEM>

<PARA>

<VARIABLELIST>

<VARLISTENTRY>

<TERM>

<ReturnValue>ALTER USER</ReturnValue>

<returnvalue>ALTER USER</returnvalue>

</TERM>

<LISTITEM>

<PARA>

<VARLISTENTRY>

<TERM>

<ReturnValue>ERROR: alterUser: user "username" does not exist</ReturnValue>

<returnvalue>ERROR: alterUser: user "username" does not exist</returnvalue>

</TERM>

<LISTITEM>

<PARA>

<REFSECT1 ID="R1-SQL-ALTERUSER-1">

<REFSECT1INFO>

<DATE>1998-04-15</DATE>

<DATE>1998-09-08</DATE>

</REFSECT1INFO>

<TITLE>

Description

</TITLE>

<PARA>

ALTER USER is used to change the attributes of a user's

PostgreSQL account. Please note that it is not possible

<command>ALTER USER</command> is used to change the attributes of a user's

<productname>Postgres</productname> account.

Please note that it is not possible

to alter a user's "usesysid" via the alter user

statement. Also, it is only possible for the PostgreSQL

statement. Also, it is only possible for the

<productname>Postgres</productname>

user or any user with read and modify permissions on

"pg_shadow" to alter user passwords.

</PARA>

<REFSECT2 ID="R2-SQL-ALTERUSER-3">

<REFSECT2INFO>

<DATE>1998-04-15</DATE>

<DATE>1998-09-08</DATE>

</REFSECT2INFO>

<TITLE>

Notes

</TITLE>

<PARA>

ALTER USER statement is a PostgreSQL language extension.

<command>ALTER USER</command> statement

is a <productname>Postgres</productname>

language extension.

</para>

<para>

Refer to CREATE/DROP USER statements to create/remove an user

Refer to <command>CREATE/DROP USER</command>

to create or remove a user

account.

</para>

<para>

At the current release (6.3.2), the IN GROUP clause is parsed

but has noeffect. When it is fully implemented, it is

In the current release (v6.4), the IN GROUP clause is parsed

but has noaffect. When it is fully implemented, it is

intended to modify the pg_group relation.

</para>

</REFSECT2>

Change a user password

</PARA>

<ProgramListing>

ALTER USER davide WITH PASSWORD hu8jmn3;

ALTER USER davide WITH PASSWORD hu8jmn3;

</ProgramListing>

<para>

Change a user's valid until date

</para>

<ProgramListing>

ALTER USER manuel VALID UNTIL 'Jan 31 2030';

ALTER USER manuel VALID UNTIL 'Jan 31 2030';

</ProgramListing>

<para>

Change a user's valid until date, specifying that his

authorisation should expire at midday on 4th May 1998 using

the time zone which is one hour ahead of UTC

</para>

<ProgramListing>

ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';

ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';

</ProgramListing>

<para>

Give a user the ability to create other users and new databases.

</para>

<programlisting>

ALTER USER miriam CREATEUSER CREATEDB;

ALTER USER miriam CREATEUSER CREATEDB;

</programlisting>

<para>

Place a user in two groups

</para>

<programlisting>

ALTER USER miriam IN GROUP sales, payroll;

ALTER USER miriam IN GROUP sales, payroll;

</programlisting>

</REFSECT1>

<REFSECT2 ID="R2-SQL-ALTERUSER-4">

<REFSECT2INFO>

<DATE>1998-04-15</DATE>

<DATE>1998-09-08</DATE>

</REFSECT2INFO>

<TITLE>

SQL92

</TITLE>

<PARA>

There is no ALTER USER statement in SQL92. The standard leaves

There is no <command>ALTER USER</command> statement in

<acronym>SQL92</acronym>.

The standard leaves

the definition of users to the implementation.

</PARA>

</refsect1>