A locale can be selected separately for each database. The SQL command

<command>CREATE DATABASE</command> and its command-line equivalent

<command>createdb</command> have options for that. Use this for example

if a database cluster houses databases for multipletennants with

if a database cluster houses databases for multipletenants with

different requirements.

</para>

</listitem>

providers</firstterm>. This specifies which library supplies the locale

data. One standard provider name is <literal>libc</literal>, which uses

the locales provided by the operating system C library. These are the

localesthatmost tools provided by the operating system use. Another

localesused bymost tools provided by the operating system. Another

provider is <literal>icu</literal>, which uses the external

ICU<indexterm><primary>ICU</primary></indexterm> library. ICU locales can

only be used if support for ICU was configured when PostgreSQL was built.

<programlisting>

initdb --locale-provider=icu --icu-locale=en

</programlisting>

See the description of the respective commands and programs for the

respectivedetails. Note that you can mix locale providerson different

See the description of the respective commands and programs for

details. Note that you can mix locale providersat different

granularities, for example use <literal>libc</literal> by default for the

cluster but have one database that uses the <literal>icu</literal>

provider, and then have collation objects using either provider within

definition has a <firstterm>provider</firstterm> that specifies which

library supplies the locale data. One standard provider name

is <literal>libc</literal>, which uses the locales provided by the

operating system C library. These are the localesthat most tools

provided by the operating system use. Another provider

operating system C library. These are the localesused by most tools

provided by the operating system. Another provider

is <literal>icu</literal>, which uses the external

ICU<indexterm><primary>ICU</primary></indexterm> library. ICU locales can only be

used if support for ICU was configured when PostgreSQL was built.

Alternatively, the ICU library can be used to provide locale services.

(Again, this only sets the default for subsequently created databases.) To

select this option, specify <literal>--locale-provider=icu</literal>.

Tochose the specific ICU locale ID to apply, use the option

Tochoose the specific ICU locale ID to apply, use the option

<option>--icu-locale</option>. Note that

for implementation reasons and to support legacy code,

<command>initdb</command> will still select and initialize libc locale