diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-02-02 14:57:46 -0500 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-02-06 11:55:39 -0500 |
| commit | 549f74733f45804cd3180de853e5d0610eecc22f (patch) | |
| tree | d98000b1630dc97f151b165158e1bb6d4ca13211 | |
| parent | a59318346ef476d3e66c4d13e92cf4ad6ce328ac (diff) | |
| download | postgresql-549f74733f45804cd3180de853e5d0610eecc22f.tar.gz postgresql-549f74733f45804cd3180de853e5d0610eecc22f.zip | |
doc: Update CREATE DATABASE examples
The example of using CREATE DATABASE with the ENCODING option did not
work anymore (except in special circumstances) and did not represent a
good general-purpose example, so write some new examples.
Reported-by: marc+pgsql@milestonerdl.com
| -rw-r--r-- | doc/src/sgml/ref/create_database.sgml | 30 |
1 files changed, 23 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index cf0d53b3014..48386a29f92 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -284,17 +284,33 @@ CREATE DATABASE sales OWNER salesapp TABLESPACE salesspace; </para> <para> - To create a database <literal>music</> which supports the ISO-8859-1 - character set: + To create a database <literal>music</> with a different locale: +<programlisting> +CREATE DATABASE music + LC_COLLATE 'sv_SE.utf8' LC_CTYPE 'sv_SE.utf8' + TEMPLATE template0; +</programlisting> + In this example, the <literal>TEMPLATE template0</> clause is required if + the specified locale is different from the one in <literal>template1</>. + (If it is not, then specifying the locale explicitly is redundant.) + </para> + <para> + To create a database <literal>music2</> with a different locale and a + different character set encoding: <programlisting> -CREATE DATABASE music ENCODING 'LATIN1' TEMPLATE template0; +CREATE DATABASE music2 + LC_COLLATE 'sv_SE.iso885915' LC_CTYPE 'sv_SE.iso885915' + ENCODING LATIN9 + TEMPLATE template0; </programlisting> + The specified locale and encoding settings must match, or an error will be + reported. + </para> - In this example, the <literal>TEMPLATE template0</> clause would only - be required if <literal>template1</>'s encoding is not ISO-8859-1. - Note that changing encoding might require selecting new - <literal>LC_COLLATE</> and <literal>LC_CTYPE</> settings as well. + <para> + Note that locale names are specific to the operating system, so that the + above commands might not work in the same way everywhere. </para> </refsect1> |