Thread: Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'
Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'
From
Martin Pitt
Date:
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
Re: Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'
From
Tom Lane
Date:
Martin Pitt <mpitt@debian.org> writes: > Recently we got the bug report below: The examples do seem to be a bit out of date compared to what the program actually does in 8.0, and showing the password entry procedure isn't a bad idea either. I've updated the reference page --- thanks for the suggestion. regards, tom lane