From: | Martin Pitt <mpitt(at)debian(dot)org> |
---|---|
To: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD' |
Date: | 2005-05-12 20:39:33 |
Message-ID: | 20050512203933.GA21489@piware.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi PostgreSQL developers!
Recently we got the bug report below:
----- Forwarded message from Jari Aalto <jari(dot)aalto(at)cante(dot)net> -----
Subject: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'
Reply-To: Jari Aalto <jari(dot)aalto(at)cante(dot)net>, 308513(at)bugs(dot)debian(dot)org
From: Jari Aalto <jari(dot)aalto(at)cante(dot)net>
To: Debian Bug Tracking System <submit(at)bugs(dot)debian(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Pitt | 2005-05-12 20:43:26 | Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file |
Previous Message | Tom Lane | 2005-05-12 20:13:00 | Re: Problem with ROWs and UNION |