Postgres Pro
Downloads
Home   >   mailing lists

moving data with pg_dump/pg_restore between database with different locale - Mailing list pgsql-general

From Zwettler Markus (OIZ)
Subject moving data with pg_dump/pg_restore between database with different locale
Date
Msg-id ZR0P278MB0105F9681BBCB546572AFD368BCCA@ZR0P278MB0105.CHEP278.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: moving data with pg_dump/pg_restore between database with different locale  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view

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

 

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Can not drop partition if exist foreign keys
Next
From: Anthony Apollis
Date:
Subject: No Data Being Inserted