Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Martin PittDate: 2005-05-12 20:43:26
Subject: Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file
Previous:From: Tom LaneDate: 2005-05-12 20:13:00
Subject: Re: Problem with ROWs and UNION

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group