~vcs-imports/mammoth-replicator/trunk

ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> SET <replaceable>parameter</replaceable> { TO | = } { <replaceable>value</replaceable> | DEFAULT }

ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RESET <replaceable>parameter</replaceable>

ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>newname</replaceable>

ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> OWNER TO <replaceable>new_owner</replaceable>

</synopsis>

</refsynopsisdiv>

<title>Description</title>

<para>

<command>ALTER DATABASE</command> changes the attributes

of a database.

</para>

<para>

The first two forms change the session default for a run-time

configuration variable for a <productname>PostgreSQL</productname>

database. Whenever a new session is subsequently started in that

database, the specified value becomes the session default value.

The database-specific default overrides whatever setting is present

in <filename>postgresql.conf</> or has been received from the

<command>postmaster</command> command line. Only the database

owner or a superuser can change the session defaults for a

database. Certain variables cannot be set this way, or can only be

set by a superuser.

</para>

<para>

The third form changes the name of the database. Only the database

owner or a superuser can rename a database; non-superuser owners must

also have the

<literal>CREATEDB</literal> privilege. The current database cannot

be renamed. (Connect to a different database if you need to do

that.)

</para>

<para>

The fourth form changes the owner of the database. Only a superuser

can change the database's owner.

</para>

</refsect1>

<title>Parameters</title>

<para>

The name of the database whose attributes are to be altered.

</para>

</listitem>

</varlistentry>

<term><replaceable>parameter</replaceable></term>

<term><replaceable>value</replaceable></term>

<para>

Set this database's session default for the specified configuration

parameter to the given value. If

<replaceable>value</replaceable> is <literal>DEFAULT</literal>

or, equivalently, <literal>RESET</literal> is used, the

database-specific setting is removed, so the system-wide default

setting will be inherited in new sessions. Use <literal>RESET

ALL</literal> to clear all database-specific settings.

</para>

<para>

See <xref linkend="sql-set" endterm="sql-set-title"> and <xref linkend="runtime-config">

for more information about allowed parameter names

and values.

</para>

100

</listitem>

101

</varlistentry>

102

103

104

<term><replaceable>newname</replaceable></term>

105

106

<para>

107

The new name of the database.

108

</para>

109

</listitem>

110

</varlistentry>

111

112

113

<term><replaceable class="parameter">new_owner</replaceable></term>

114

115

<para>

116

The new owner of the database.

117

</para>

118

</listitem>

119

</varlistentry>

120

</variablelist>

121

</refsect1>

122

123

124

<title>Notes</title>

125

126

<para>

127

It is also possible to tie a session default to a specific user

128

rather than to a database; see

129

<xref linkend="sql-alteruser" endterm="sql-alteruser-title">.

130

User-specific settings override database-specific

131

ones if there is a conflict.

132

</para>

133

</refsect1>

134

135

136

<title>Examples</title>

137

138

<para>

139

To disable index scans by default in the database

140

<literal>test</literal>:

141

142

143

ALTER DATABASE test SET enable_indexscan TO off;

144

</programlisting>

145

</para>

146

</refsect1>

147

148

149

<title>Compatibility</title>

150

151

<para>

152

The <command>ALTER DATABASE</command> statement is a

153

<productname>PostgreSQL</productname> extension.

154

</para>

155

</refsect1>

156

157

158

159

160

161

162

163

164

</simplelist>

165

</refsect1>

166

</refentry>

167

168

<!-- Keep this comment at the end of the file

169

Local variables:

170

mode: sgml

171

sgml-omittag:nil

172

sgml-shorttag:t

173

sgml-minimize-attributes:nil

174

sgml-always-quote-attributes:t

175

sgml-indent-step:1

176

sgml-indent-data:t

177

sgml-parent-document:nil

178

sgml-default-dtd-file:"../reference.ced"

179

sgml-exposed-tags:nil

180

sgml-local-catalogs:"/usr/lib/sgml/catalog"

181

sgml-local-ecat-files:nil

182

End:

183

-->

Older »