On Tue, Mar 17, 2020 at 8:06 AM Don Seiler <don@seiler.us> wrote:
On Mon, Mar 16, 2020 at 10:28 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Well, in principle you could likewise manually update pg_database's datcollate and datctype columns to say "en_US.utf8". However, there's a much bigger problem here --- what steps if any did this cowboy take to ensure that the data inside the database was valid UTF8?
Is there a way to programmatically check for data that might be a problem now?