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
