The PostgreSQL block executes a SQL query on a PostgreSQL database and returns the response.
To run this block, you will first need to add the connection string of your PostgreSQL databaseso that it’s encrypted and stored securely within Keyflow. Navigate to your credentials page and connect add connection string to “PostgreSQL” integration
I/O | Feature | Type | Simple Explanation |
---|---|---|---|
input | query | string | The SQL query you want to run on the PostgreSQL database. |
input | data (optional) | object | A set of parameters to format your query dynamically if needed. |
output | query_response | string | The JSON string containing the response from the executed query. |
Explore how this block enhances functionality across various applications:
In essence, the PostgreSQL Query Executor
block serves as a powerful tool in managing and manipulating your database interactions effortlessly!