[syslog-ng] Database field types

[Balazs Scheidler]

On Fri, 2009-03-06 at 19:08 -0800, Liam Kirsher wrote:
> Hi --
> 
> I notice that when the database tables get created all the fields are
> 'text' type.  That is okay.
> However, it might in some cases be convenient for us to have different
> field types.
> Is there any problem with that?
> If we create the table with the desired field types, will that take care
> of it (assuming the data actually matches the type)?

you can specify the field type, like this:

sql(columns("date datetime"));

e.g. separate the type with a space from the column name.

-- 
Bazsi