Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'

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
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</userinput>
-<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</computeroutput>
 <computeroutput>CREATE USER</computeroutput>
 </screen>
    </para>

--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntulinux.org
Debian Developer http://www.debian.org