Skip to Content

In the Spotlight February 2012

In TKU February 2012 an update was made to the PostgreSQL RDBMS pattern and we have developed a pattern to perform extended database discovery pattern of this database.

Extended PostgreSQL pattern obtains the list of Databases, Schemas and Tables which belong to specific PostgreSQL instance:
PostgreSQL.jpg

Here is an example of "PostgreSQL Database" Detail:
PostgreSQL_DB.jpg

The pattern is able to use one of the following methods for obtaining database details information:

  • command method
  • sql query method
  • file method

Found Databases, Schemas and Tables are modeled as "Database Detail" and have the following structure:
PostgreSQLDBDetails.jpg

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Discovery content reference