Introduction
This integration enables users to perform a Lookup Row action, checking for the existence of a specific row in a Postgres SQL database. Utilizing Postgres' EXISTS subquery function, the action efficiently verifies data presence without retrieving the entire row. This capability is particularly useful for validating data or conditionally executing subsequent operations based on the row's existence in the database.
Provider: https://postgresql.org
API Documentation: https://www.postgresql.org/docs/current/functions-subquery.html#FUNCTIONS-SUBQUERY-EXISTS
Input
Name | Is Optional | Description | Type |
SQL Query | Raw SELECT SQL Query to Run | text | |
Host IP Address | Public IP address for your PostgreSQL database (localhost is not valid). | text | |
Port | The port number used to connect to your PostgreSQL database | number | |
Database Name | Name of the database to query | text | |
Schema | true | The schema that contains the tables you'll query (If you're unsure, leave this blank) | text |
Output
Name | Type |
array |