Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal DiscoveryContent Pack 28.00 (CP28)

Use > Discovery Modules > Database > PostgreSQL Discovery > PostgreSQL Connection by SQL job

PostgreSQL Connection by SQL job

This section includes details about the job.

Trigger TQL

Node Name	Condition
Node	None
PostgreSQL	None
IpAddress	NOT IP Probe Name Is null
IpServiceEndpoint	IpServiceName Equal ignore case postgresql OR ServiceNames Contains postgresql

Adapter

This job uses the PostgreSQL Connection by SQL adapter.

Triggered CI Data

Required Permissions

Permission	Operation	Usage Description	Objects and Parameters
SQL	select	Check PostgreSQL database version	version()

Discovered CITs
- Composition
- Containment
- IpAddress
- IpServiceEndpoint
- Node
- PostgreSQL
- Usage

Adapter Parameters

Parameter	Default Value	Description
protocolType	postgresql	The used protocol type.