[Bucardo-general] Filtering columns while copying

Christophe Pettus xof at thebuild.com
Thu Feb 28 20:17:30 UTC 2019



> On Feb 28, 2019, at 12:12, David Christensen <david at endpoint.com> wrote:
> 
> So say you define a plperl function on your source database “fix_encoding()” that just basically wraps the Encoding::FixLatin routine, then define the customcols for each table in the sync to include instead of “SELECT textfield1, field2 FROM table1”, “SELECT fix_encoding(textfield1), field2 FROM table1”.  It would be easy enough to query the system tables and generate the appropriate customcols definition for each table depending on field type.

Oh, clever!   I'll explore that... thanks!
--
-- Christophe Pettus
   xof at thebuild.com



More information about the Bucardo-general mailing list