The PostgreSQL SELECT action is used to execute a select query against a PostgreSQL database.
The input parameters for an insert statement are:
| Parameter | Type | Required | Description |
|---|---|---|---|
| query | String | Required | The query to execute against the database |
| metadata | JSON | Optional | The list of parameters to pass to the query |
The metadata parameter can be used to pass variables into the query parameter.
For example, if the contents of metadata are:
{
"type" : "mint"
}
This can be used in the query parameter as:
SELECT TOP 10 * FROM flavors
WHERE flavor = {type}
ORDER BY ingredients DESC;
Note: The { } are declared without quotations.
The output parameters from a select query are:
| Parameter | Type | Required | Description |
|---|---|---|---|
| result | Integer | Optional | A JSON object containing the selected data. |