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