title: Rsyslog to PostgreSQL works fine but not all columns are filled
body: <p>I configured correctly to store the syslog messages in PostgreSQL as shown in this image, but ntseverity, importance, eventsource, etc are null:</p>
  
  <p><a href="https://i.stack.imgur.com/6FK5z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6FK5z.png" alt="PostgreSQL and rsyslog message"></a></p>
  
  <p>This is my configuration until now:</p>
  
  <pre><code>## Configuration file for rsyslog-pgsql
  ### Changes are preserved
  
  module (load="ompgsql")
  *.* action(type="ompgsql" server="localhost" db="syslog" uid="rsyslogu" pwd="*********")
  </code></pre>
  
  <p>Seems a template has to be created as shown in:
  <a href="https://www.rsyslog.com/doc/v8-stable/configuration/modules/ompgsql.html" rel="nofollow noreferrer">https://www.rsyslog.com/doc/v8-stable/configuration/modules/ompgsql.html</a></p>
  
  <p>How can I set the template for those extra columns to be filled?
  Does someone have the remaining columns in the template?</p>
  
  <pre><code>template(name="sql-syslog" type="list" option.sql="on") {
    constant(value="INSERT INTO SystemEvents (message, timereported) values ('")
    property(name="msg")
    constant(value="','")
    property(name="timereported" dateformat="pgsql" date.inUTC="on")
    constant(value="')")
  }
  </code></pre>