Hi PostgreSQL developers! Recently we got the bug report below:
----- Forwarded message from Jari Aalto <[EMAIL PROTECTED]> -----
Subject: Bug#308513: postgresql-client: [manual] createuser(1) Add example
'...WITH PASSWORD'
Reply-To: Jari Aalto <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
From: Jari Aalto <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
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
signature.asc
Description: Digital signature
