PostgreSQL

The PostgreSQL connector allows you to connect applications with the PostgreSQL database, and manage data transmission.

PostgreSQL is a full-featured, open-source object-relational database.
The default PostgreSQL port number is 5432. The administrator can change the port number as required.

Log in to the new ROMA Connect console.
In the navigation pane on the left, choose Connector. On the page displayed, click New Connection.
Select the PostgreSQL connector.

In the dialog box displayed, configure the connector and click OK.

Parameter	Description
Name	Enter the connector instance name.
Region	Select a region.
Project	Select a project.
Instance	Select an instance for subsequent connectivity verification.
Connection and Security	Select the connection mode for the database. Default: The system automatically concatenates data source connection character strings based on configured data. Professional: You need to specify the data source connection string manually.
IP Address	Required when Connection and Security is set to Default. Enter the IP address of the database.
Port	Required when Connection and Security is set to Default. Enter the port number to which the database is connected.
Database Name	Required when Connection and Security is set to Default. Enter the name of the database to be connected.
Connection String	Required when Connection and Security is set to Professional. Enter the JDBC connection string of the PostgreSQL database, for example, jdbc:postgresql://{hostname}:{port}/{dbname}.
Username	Enter the username used to connect to the database.
Password	Enter the password used to connect to the database.
Description	Enter the description of the connector to identify it.

The PostgreSQL connector supports English table names only (Chinese unsupported).

**Table 1** Obtaining records
Parameter	Description
Table Name	Select or enter the table name in the database to be queried.
Field Name	Select the field name of the data table to be queried.
WHERE Condition	Set the condition value in single quotation marks.
Order By Field	Enter the sorting field of the returned result.
Limits	Enter the number of records on each page in the returned result.
Offset	Enter the offset of the pagination query.

**Table 2** Adding records
Parameter	Description
Table Name	Select or enter the name of the table to which data is to be inserted.
Data to Insert	Enter the target field value in single quotation marks.

**Table 3** Updating records
Parameter	Description
Table Name	Select or enter the name of the table where data is to be updated.
Update Data	Enter the target field value in single quotation marks.
WHERE Condition	Set the condition value in single quotation marks.

**Table 4** Replicating records
Parameter	Description
Table Name	Select or enter the name of the table where data is to be synchronized.
Clear Table	Whether to clear the table each time data is replicated.

**Table 5** Obtaining incremental records
Parameter	Description
Table Name	Select or enter the name of the table to obtain incremental records.
Field Name	Select the field name of the data table to be queried.
WHERE Condition	Set the condition value in single quotation marks.
Order By Field	Enter the sorting field of the returned result.
Start Timezone for incremental database selection	Start time zone for obtaining incremental data.
Incremental Selection Timestamp Field Name	Timestamp field for obtaining incremental data.
Incremental Selection Timestamp Initial Value	Initial timestamp for obtaining incremental data.
Reset Initial Incremental Selection Time	Whether to enable the reset of the initial time for obtaining incremental data.
Incremental Selection Compensation Period (ms)	Time compensation for obtaining incremental data.

**Table 6** Deleting records
Parameter	Description
Table Name	Select or enter the name of the table where data is to be deleted.
WHERE Condition	Set the condition value in single quotation marks.

**Table 7** Custom SQL
Parameter	Description
Statement	Statements display all your inputs as plain text. Do not include sensitive information. Only one select, update, insert, or delete statement can be executed. The select statement can return up to 500 records.

**Table 8** Output parameters
Parameter	Description
Payload	Response in JSON format, with keys as the database field names and values as their corresponding data. Entries on each line are comma-separated. For payload details, see Referencing Variables.
Updated count	Number of updated rows.
Selected count	Number of rows of data queried.
Start time	Start time of node execution.
End time	End time of node execution.
Execution time	Node execution duration, in milliseconds.