Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       ALTER DATABASE -

SYNOPSIS

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

       ALTER DATABASE name RENAME TO newname

DESCRIPTION

       ALTER DATABASE

         PostgreSQL    SET variable TO value  postgresql.conf  postmaster

         CREATEDB

PARAMETERS

       name

       parameter

       value
                 value  DEFAULT  RESET   RESET ALL

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

       newname

NOTES

         ALTER USER [alter_user(7)]

EXAMPLES

         test

       ALTER DATABASE test SET enable_indexscan TO off;

COMPATIBILITY

       ALTER DATABASE  PostgreSQL

SEE ALSO

       ALTER  USER [alter_user(7)], CREATE DATABASE [create_database(l)], DROP
       DATABASE [drop_database(l)], SET [set(l)]

       Postgresql  <laser@pgsqldb.org>