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.