diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-05-26 13:57:04 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-05-26 13:57:04 +0000 |
| commit | cfbfdc557d166ec559668d18d9769544f3c4fbbc (patch) | |
| tree | b487d06389fcb3a304524c2cf0adfc769348c0ae /doc/src | |
| parent | d0b4399d81f39decccb23fa38f772b71b51bf96a (diff) | |
| download | postgresql-cfbfdc557d166ec559668d18d9769544f3c4fbbc.tar.gz postgresql-cfbfdc557d166ec559668d18d9769544f3c4fbbc.zip | |
This patch implement the TODO [ALTER DATABASE foo OWNER TO bar].
It was necessary to touch in grammar and create a new node to make home
to the new syntax. The command is also supported in E
CPG. Doc updates are attached too. Only superusers can change the owner
of the database. New owners don't need any aditional
privileges.
Euler Taveira de Oliveira
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_database.sgml | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_database.sgml b/doc/src/sgml/ref/alter_database.sgml index aa34fac9f05..86093712f88 100644 --- a/doc/src/sgml/ref/alter_database.sgml +++ b/doc/src/sgml/ref/alter_database.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.11 2003/11/29 19:51:38 pgsql Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_database.sgml,v 1.12 2004/05/26 13:56:42 momjian Exp $ PostgreSQL documentation --> @@ -23,6 +23,8 @@ PostgreSQL documentation 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> OWNER TO <replaceable>new_owner</replaceable> + ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>newname</replaceable> </synopsis> </refsynopsisdiv> @@ -54,6 +56,11 @@ ALTER DATABASE <replaceable class="PARAMETER">name</replaceable> RENAME TO <repl 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> <refsect1> |