Reg:CHARSET_COVERSION_LATIN_TO_UTF8

Hi Team, I have the postgresql database with 11.4 Version in AWS RDS. Some of the columns have lattin collate format. I need to migrate the database to Azure postgresql and need to convert UTF8 column format. How to find which columns are in Latin format. How to convert the data and columns to

Re: Dirty buffers with suppress_redundant_updates_trigger

On Sun, 2020-09-13 at 13:49 +0200, Mike Noordermeer wrote: > Hi, > > I am currently working on a data sync solution, where data is synced > from external systems to Postgres. As I do not know what data changed > in the source data store, I have opted for the following flow: > > - Load all data

Dirty buffers with suppress_redundant_updates_trigger

Hi, I am currently working on a data sync solution, where data is synced from external systems to Postgres. As I do not know what data changed in the source data store, I have opted for the following flow: - Load all data in a temp table - Update existing rows main table based on contents of

Re: How to call JSONB_INSERT with integer as the new to-be-inserted value?

Thank you!