Template¶

Selects the template used for the SQL INSERT statement sent to PostgreSQL.

This parameter applies to PostgreSQL Database Output Module (ompgsql).

Name:: Template
Scope:: input
Type:: word
Default:: StdPgSQLFmt
Required?:: no
Introduced:: 8.32.0

Description¶

The template name to use to INSERT rows into the database with. Valid SQL syntax is required, as the module does not perform any insertion statement checking.

Input usage¶

module(load="ompgsql")
action(type="ompgsql" server="localhost" db="syslog" template="sql-syslog")

See also¶

See also PostgreSQL Database Output Module (ompgsql).

Support: rsyslog Assistant | GitHub Discussions | GitHub Issues: rsyslog source project

Contributing: Source & docs: rsyslog source project

© 2008–2025 Rainer Gerhards and others. Licensed under the Apache License 2.0.

nnnn