This property specifies the format of the name that the PostgreSQL plug-in assigns to auto-discovered PostgreSQL Table and vPostgreSQL Table table types.

By default, the name of a PostgreSQL or vPostgreSQL table is Table DatabaseName.Schema.Table, comprising the following variables

Variable

Description

DatabaseName

The auto-discovered name of the database.

Schema

The auto-discovered schema for the database.

Table

The auto-discovered name of the table.

To use a different naming convention, define postgresql.table.name.format. The variable data you use must be available from the PostgreSQL plug-in.

Use the following syntax to specify the default table name assigned by the plug-in,

Table ${db}.${schema}.${table}

where

Attribute

Description

db

Identifies the platform that hosts the PostgreSQL or vPostgreSQL server.

schema

Identifies the schema associated with the table.

table

The table name in PostgreSQL.

By default, the agent.properties file does not include this property.