Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       ALTER USER -

SYNOPSIS

       ALTER USER name [ [ WITH ] option [ ... ] ]

       where option can be:

           [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
           | CREATEDB | NOCREATEDB
           | CREATEUSER | NOCREATEUSER
           | VALID UNTIL 'abstime'

       ALTER USER name RENAME TO newname

       ALTER USER name SET parameter { TO | = } { value | DEFAULT }
       ALTER USER name RESET parameter

DESCRIPTION

       ALTER USER  PostgreSQL

           postgresql.conf  postmaster

PARAMETERS

       name

       password

       ENCRYPTED

       UNENCRYPTED
                pg_shadow CREATE USER [create_user(7)]

       CREATEDB

       NOCREATEDB
                CREATEDB NOCREATEDB

       CREATEUSER

       NOCREATEUSER

       abstime
                'infinity'

       newname

       parameter

       value
                 value  DEFAULT   RESET  RESET ALL

                SET [set(7)]  Section 16.4 ``Run-time Configuration''

NOTES

         CREATE USER [create_user(7)]  DROP USER [drop_user(7)]

       ALTER USER ALTER GROUP [alter_group(7)]

         ALTER DATABASE [alter_database(7)]

EXAMPLES

       ALTER USER davide WITH PASSWORD 'hu8jmn3';

       ALTER USER manuel VALID UNTIL 'Jan 31 2030';

         UTC 2005  5  4

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

       ALTER USER fred VALID UNTIL 'infinity';

       ALTER USER miriam CREATEUSER CREATEDB;

COMPATIBILITY

       ALTER USER  PostgreSQL SQL

SEE ALSO

       CREATE USER [create_user(7)], DROP USER [drop_user(l)], SET [set(l)]

       Postgresql  <laser@pgsqldb.org>