From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: moving data with pg_dump/pg_restore between database with different locale
Date: Wed, 11 Oct 2023 18:49:23 +0200
Message-ID: <61aec9b659252bc9cef1db5266a023abde25ce9f.camel@cybertec.at> (raw)
In-Reply-To: <ZR0P278MB0105F9681BBCB546572AFD368BCCA@ZR0P278MB0105.CHEP278.PROD.OUTLOOK.COM>
References: <ZR0P278MB0105F9681BBCB546572AFD368BCCA@ZR0P278MB0105.CHEP278.PROD.OUTLOOK.COM>
On Wed, 2023-10-11 at 11:34 +0000, Zwettler Markus (OIZ) wrote:
> if you want to retrieve data by means of pg_dump / pg_restore from a database with
> locale de_CH.UTF8 into a database with locale en_US.UTF8 are there any other things
> to consider than the behavior implications mentioned in the documentation:
The sort order will change, the language of error messages and the log file
will change (unless you set lc_messages differently), some format letters in
to_timestamp(), to_number() and to_char() will change semantics (unless you
set lc_numeric and lc_time differently).
That's about it.
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: laurenz.albe@cybertec.at, Markus.Zwettler@zuerich.ch
Subject: Re: moving data with pg_dump/pg_restore between database with different locale
In-Reply-To: <61aec9b659252bc9cef1db5266a023abde25ce9f.camel@cybertec.at>
References: <ZR0P278MB0105F9681BBCB546572AFD368BCCA@ZR0P278MB0105.CHEP278.PROD.OUTLOOK.COM> <61aec9b659252bc9cef1db5266a023abde25ce9f.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox