Yeah that will work for sure.  I can’t imagine there’s a very good way to validate syntax though.


On Mar 7, 2017, at 5:01 AM, Scheidler, Balázs <balazs.scheidler@balabit.com> wrote:

Hi,

I was thinking about a more generic approach, but this could solve your problem:

https://github.com/balabit/syslog-ng/pull/1367

This creates a create-statement-append() option to the sql destination where you can specify a string that gets appended to the CREATE SQL statement.

If it indeed solves your problem, I'd welcome feedback on the #1367 github issue. This is just a quick and dirty patch from me, without tests etc.


--
Bazsi