Revision History

1.0.0.0 Initial Release

1.0.0.2 Minor Update

Properties

Connection

Type: Connection Input

Server
Type: String
The name or IP address of the server hosting the PostGreSQL Server instance. Specify a DropPoint if you need to access a SQL instance that is not Internet-exposed.

Database
Type: String
The name of the database to connect to.

Username
Type: String
The SQL username to be used for the connection.

Password
Type: Password
The SQL password to be used for the connection.

SSLMode

Type: List

Determines what SSL configuration to use. See Client Verification of Server Certificates.

Remarks

Use this Connector to execute PostgreSQL queries against a PostgreSQL Server instance.

SQL Parameters via Custom Properties

Flowgear Custom Properties can be added to this Node to make SQL parameters available in the Query Property. Use of a Custom Property is shown in the linked example workflow (see Examples below).

Other Nodes for SQL databases

If you are updating values in a table based on keys, consider using PostgreSQL Table Update instead of crafting update statements.

Examples

The patterns from https://flowgear.me/s/zDCFM3N and https://flowgear.me/s/PuUSi5c can be used to request and emit a single page of data respectively. Simply replace the Microsoft SQL Query Node with the PostgreSQL node found here: https://flowgear.me/s/cXI4SpF.

See Also

PostgreSQL Official Documentation

Did this answer your question?