alter_database

ALTER DATABASE()		 SQL Commands		     ALTER DATABASE()



NAME
       ALTER DATABASE - change a database


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

       ALTER DATABASE name RENAME TO newname


DESCRIPTION
       ALTER DATABASE is used to change the attributes of a database.

       The  first two forms change the session default of a run-time configu-
       ration variable for a PostgreSQL database. Whenever a new  session  is
       subsequently started in that database, the specified value becomes the
       session default value.  The database-specific default overrides	what-
       ever  setting  is present in postgresql.conf or has been received from
       the postmaster command line. Only the database owner  or	 a  superuser
       can change the session defaults for a database.

       The  third  form	 changes  the name of the database. Only the database
       owner can rename a database, and only if he has	the  CREATEDB  privi-
       lege.  The current database cannot be renamed. (Connect to a different
       database if you need to do that.)

PARAMETERS
       name   The name of the database	whose  session	defaults  are  to  be
	      altered.

       parameter

       value  Set the session default for this database of the specified con-
	      figuration parameter to the given value. If  value  is  DEFAULT
	      or, equivalently, RESET is used, the database-specific variable
	      setting is removed and the system-wide default setting will  be
	      inherited in new sessions. Use RESET ALL to clear all settings.

	      See SET [set(7)] and [XRef to RUNTIME-CONFIG] for more informa-
	      tion about allowed parameter names and values.

       newname
	      The new name of the database.

NOTES
       Using ALTER USER [alter_user(7)], it is also possible to tie a session
       default to a specific user rather than a database. User-specific	 set-
       tings override database-specific ones if there is a conflict.

EXAMPLES
       To disable index scans by default in the database test:

       ALTER DATABASE test SET enable_indexscan TO off;


COMPATIBILITY
       The ALTER DATABASE statement is a PostgreSQL extension.

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



SQL - Language Statements	  2008-01-03		     ALTER DATABASE()