postgres.git / summary / log / commit / refs

commit    c709b113e8f5433ea2a66b2fb08d9324dd596642
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Tue Mar 21 01:23:56 2017 +0000

    doc:  improve createdb example
    
    The previous example could error out due to encoding mismatches;  use
    -T/template instead.
    
    Reported-by: Jason O'Donnell


doc/src/sgml/ref/createdb.sgml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index c363bd4a565..9fc4c16a810 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -363,11 +363,11 @@ PostgreSQL documentation <para> To create the database <literal>demo</literal> using the server on host <literal>eden</>, port 5000, using the - <literal>LATIN1</literal> encoding scheme with a look at the - underlying command: + <literal>template0</literal> template database, here is the + command-line command and the underlying SQL command: <screen> -<prompt>$ </prompt><userinput>createdb -p 5000 -h eden -E LATIN1 -e demo</userinput> -<computeroutput>CREATE DATABASE demo ENCODING 'LATIN1';</computeroutput> +<prompt>$ </prompt><userinput>createdb -p 5000 -h eden -T template0 -e demo</userinput> +<computeroutput>CREATE DATABASE demo TEMPLATE template0;</computeroutput> </screen></para> </refsect1> [parent: aa740b59a684]