Provides integration with a Postgre SQL Database.
0.0.0.3 - Initial release.
| Parameter |
Type |
Description |
Server |
String |
The name or IP address of the server hosting the PostgreSQL Server instance. |
Port |
Integer |
The port to connect to. |
Database |
String |
The name of the database to connect to. |
Username |
String |
The PostgreSQL username to be used for the connection. |
Password |
Masked |
The PostgreSQL password to be used for the connection. |
SslMode |
Dropdown |
Determines what SSL configuration to use. Options: Disable, Allow, Prefer, Require, VerifyCA, VerifyFull. |
Trust Server Certificate |
Boolean |
Whether to trust the server certificate without validating it. |
Connection Timeout |
Integer |
The time to wait (in seconds) while trying to establish a connection before terminating the attempt and generating an error. Default is 15 seconds. |
Enable Detailed Responses |
Boolean |
Includes more verbose error responses. |
Enable Legacy Timestamp Behavior |
Boolean |
Whether to trust the server certificate without validating it.evert to the legacy timestamp behavior prior to Npgsql version 6.0, this setting enables Npgsql.EnableLegacyTimestampBehavior and Npgsql.DisableDateTimeInfinityConversions. |
Executes a query against a Postgre SQL database and returns the results.
| Parameter |
Type |
Notes |
Connection |
Connection |
The connection profile. |
Query |
String |
The query to execute. |
| Return |
Type |
Notes |
Items |
Array |
Output from Query. |
Upserts data to a Postgre SQL database table.
| Parameter |
Type |
Notes |
Connection |
Connection |
The connection profile. |
TableName |
String |
The name of the table to upsert. |
KeyFields |
String |
A comma-separated list of fields that represent key fields for the upsert operation. |
Items |
Array |
The items to upsert. |
| Return |
Type |
Notes |
RowsAffected |
Integer |
The amount of rows that were affected by the Upsert statement. |
- Listen method not implemented yet.