Database - PostgreSQLUpdate
This system keyword is used for modification operations on PostgreSQL database.
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
Ip |
Yes |
String |
Database IP address. For a Huawei Cloud RDS instance, you need to bind an EIP to the instance and ensure that the security group policy of the instance port is enabled to allow access. Connecting to an RDS for PostgreSQL Instance. |
Port |
Yes |
Integer |
Database port |
DB Name |
Yes |
String |
Database instance name |
User Name |
Yes |
String |
Username |
Password |
Yes |
String |
Password (The login password is personal information and must be defined as sensitive in the environment parameters.) |
Sql |
Yes |
String |
SQL statement, such as UPDATE, which has no returns |
PostgreSQLUpdate Response
Status: success
Parameter |
Type |
Description |
|---|---|---|
affected_row_count |
Integer |
Number of rows affected by the SQL statement |
PostgreSQLUpdate Response Example
{
"affected_row_count": 1
}
PostgreSQLUpdate Usage Example
Determine the number of affected rows.
Feedback
Was this page helpful?
Provide feedbackFor any further questions, feel free to contact us through the chatbot.
Chatbot
