2 $PostgreSQL: pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.13 2004/07/05 02:34:43 momjian Exp $
3 PostgreSQL documentation
6 <refentry id="SQL-ALTERDATABASE">
8 <refentrytitle id="sql-alterdatabase-title">ALTER DATABASE</refentrytitle>
9 <refmiscinfo>SQL - Language Statements</refmiscinfo>
13 <refname>ALTER DATABASE</refname>
14 <refpurpose>change a database</refpurpose>
17 <indexterm zone="sql-alterdatabase">
18 <primary>ALTER DATABASE</primary>
23 ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> SET <replaceable>parameter</replaceable> { TO | = } { <replaceable>value</replaceable> | DEFAULT }
24 ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replaceable>parameter</replaceable>
26 ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>newname</replaceable>
28 ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> OWNER TO <replaceable>new_owner</replaceable>
33 <title>Description</title>
36 <command>ALTER DATABASE</command> is used to change the attributes
41 The first two forms change the session default of a run-time
42 configuration variable for a <productname>PostgreSQL</productname>
43 database. Whenever a new session is subsequently started in that
44 database, the specified value becomes the session default value.
45 The database-specific default overrides whatever setting is present
46 in <filename>postgresql.conf</> or has been received from the
47 <command>postmaster</command> command line. Only the database
48 owner or a superuser can change the session defaults for a
53 The third form changes the name of the database. Only the database
54 owner can rename a database, and only if he has the
55 <literal>CREATEDB</literal> privilege. The current database cannot
56 be renamed. (Connect to a different database if you need to do
61 The fourth form changes the owner of the database. Only a superuser
62 can change the database's owner.
67 <title>Parameters</title>
71 <term><replaceable class="PARAMETER">name</replaceable></term>
74 The name of the database whose session defaults are to be altered.
80 <term><replaceable>parameter</replaceable></term>
81 <term><replaceable>value</replaceable></term>
84 Set the session default for this database of the specified
85 configuration parameter to the given value. If
86 <replaceable>value</replaceable> is <literal>DEFAULT</literal>
87 or, equivalently, <literal>RESET</literal> is used, the
88 database-specific variable setting is removed and the system-wide
90 setting will be inherited in new sessions. Use <literal>RESET
91 ALL</literal> to clear all settings.
95 See <xref linkend="sql-set" endterm="sql-set-title"> and <xref linkend="runtime-config">
96 for more information about allowed parameter names
103 <term><replaceable>newname</replaceable></term>
106 The new name of the database.
117 Using <xref linkend="sql-alteruser" endterm="sql-alteruser-title">,
118 it is also possible to tie a session default to a specific user
119 rather than a database. User-specific settings override database-specific
120 ones if there is a conflict.
125 <title>Examples</title>
128 To disable index scans by default in the database
129 <literal>test</literal>:
132 ALTER DATABASE test SET enable_indexscan TO off;
138 <title>Compatibility</title>
141 The <command>ALTER DATABASE</command> statement is a
142 <productname>PostgreSQL</productname> extension.
147 <title>See Also</title>
149 <simplelist type="inline">
150 <member><xref linkend="sql-alteruser" endterm="sql-alteruser-title"></member>
151 <member><xref linkend="sql-createdatabase" endterm="sql-createdatabase-title"></member>
152 <member><xref linkend="sql-dropdatabase" endterm="sql-dropdatabase-title"></member>
153 <member><xref linkend="sql-set" endterm="sql-set-title"></member>
158 <!-- Keep this comment at the end of the file
163 sgml-minimize-attributes:nil
164 sgml-always-quote-attributes:t
167 sgml-parent-document:nil
168 sgml-default-dtd-file:"../reference.ced"
169 sgml-exposed-tags:nil
170 sgml-local-catalogs:"/usr/lib/sgml/catalog"
171 sgml-local-ecat-files:nil