<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Yeah that will work for sure. I can’t imagine there’s a very good way to validate syntax though.</div><div class=""><br class=""></div><br class=""><div><blockquote type="cite" class=""><div class="">On Mar 7, 2017, at 5:01 AM, Scheidler, Balázs <<a href="mailto:balazs.scheidler@balabit.com" class="">balazs.scheidler@balabit.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class=""><div class=""><div class="">Hi,<br class=""><br class=""></div>I was thinking about a more generic approach, but this could solve your problem:<br class=""><br class=""><a href="https://github.com/balabit/syslog-ng/pull/1367" class="">https://github.com/balabit/syslog-ng/pull/1367</a><br class=""><br class=""></div>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.<br class=""><br class=""></div>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.<br class=""><br class=""></div><div class="gmail_extra"><br clear="all" class=""><div class=""><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr" class="">-- <br class="">Bazsi</div></div></div></div></div></blockquote></div></body></html>