Hi PostgreSQL developers!
Recently we got the bug report below:
----- Forwarded message from Jari Aalto <jari.aalto@cante.net> -----
Subject: Bug#308513: postgresql-client: [manual] createuser(1) Add example =
'...WITH PASSWORD'
Reply-To: Jari Aalto <jari.aalto@cante.net>, 308513@bugs.debian.org
From: Jari Aalto <jari.aalto@cante.net>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Date: Tue, 10 May 2005 20:28:53 +0300
Package: postgresql-client
Version: 7.4.7-6
Severity: minor
createuser(1) is well laid manual and it reads:
EXAMPLES
...
$ createuser -p 5000 -h eden -D -A -e joe
CREATE USER "joe" NOCREATEDB NOCREATEUSER
CREATE USER
For completeness, please also add this example:
CREATE USER 'joe' WITH PASSWORD 'secret';
Btw, Whouldn't the "joe" in manual be 'joe', since SQL standard does
not allow to use double quotes for strings; the single quote is=20
reserved for that.
[...]
----- End forwarded message -----
The "joe" typo should be fixed in any case, and I also think that the
password example is a good idea. What do you think about this patch?
Thanks for considering and have a nice day!
Martin
--- postgresql-7.4.7-old/doc/src/sgml/ref/createuser.sgml 2003-09-13 =
01:04:46.000000000 +0200
+++ postgresql-7.4.7/doc/src/sgml/ref/createuser.sgml 2005-05-10 23:33:50=
.476330448 +0200
@@ -302,7 +302,16 @@
taking a look at the underlying command:
<screen>
<prompt>$ </prompt><userinput>createuser -p 5000 -h eden -D -A -e joe</use=
rinput>
-<computeroutput>CREATE USER "joe" NOCREATEDB NOCREATEUSER</computeroutput>
+<computeroutput>CREATE USER joe NOCREATEDB NOCREATEUSER</computeroutput>
+<computeroutput>CREATE USER</computeroutput>
+</screen>
+ </para>
+
+ <para>
+ To create the <literal>joe</literal> user with a password:
+<screen>
+<prompt>$ </prompt><userinput>createuser -e joe -P -d -a</userinput>
+<computeroutput>CREATE USER joe PASSWORD 'secret' CREATEDB CREATEUSER</com=
puteroutput>
<computeroutput>CREATE USER</computeroutput>
</screen>
</para>
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntulinux.org
Debian Developer http://www.debian.org