Execute a query in PostgreSQL
Execute a query in a PostgreSQL database.
Application
Inputs (what you have)
| Name | Description | Data Type | Required? | Example |
|---|
| PostgreSQL connected account | The credentials for the PostgreSQL server | Connected Account | Yes | |
| Query | The SQL query to execute | Text (Long) | Yes | SELECT * FROM users;' |
Outputs (what you get)
| Name | Description | Data Type | Required? | Example |
|---|
| Server message | Message from the server regarding the executed query | Text (Long) | No | |
| Output JSON | JSON output returned by the API | Text (Long) | No | |
| Total number of rows | Number of rows returned as part of the query | Number | No | |
Outcomes
| Name | Description |
|---|
| Success | This status is selected if the job has successfully completed. |
| Unsuccessful | This status is selected if the job has completed unsuccessfully. |
Requirements