moving data with pg_dump/pg_restore between database with different locale
hi,
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:
https://www.postgresql.org/docs/current/locale.html#LOCALE-BEHAVIOR
Thanks,
Markus
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