Htykuut

Is it possible to only display the name of the database in the message column?

I have a simple syslog-ng configuration:

destination d_pgsql3{

sql(

    type(pgsql)

    host("localhost")

    username("logwriter")

    password("1234")

    port("5432")

    database("syslog")

    table("smietnik")

    columns("id_loga serial", "datetime text",  "host text", "program text", "pid text", "facility text", "level text","message text")

    values(default, "$R_DATE", "$HOST", "$PROGRAM", "$PID", "$FACILITY", "$LEVEL", "$MSG")

    indexes("id_loga", "datetime", "host", "program", "pid", "facility", "level", "message")

);

};

filter f_demo_filter3 { not match( "testy " value("MSG")) or not match( "testy2 " value("MSG")) };

log { source(src); filter(f_local5);  filter(f_demo_filter3); destination(d_pgsql3); };

postgres from another host sends a log about the creation of the database, the logging database receives this log and inserts into the table.

I would like the message entering the table to be only the name of the database.

In my example: jezdze

Is this possible using the syslog-ng configuration?