PostgreSQL Snap Pack
Overview
Use the PostgreSQL Snap Pack to connect to your PostgreSQL database and achieve read and write access to its objects.
-
PostgreSQL Select: Fetches data from a PostgreSQL database by providing a table name.
-
PostgreSQL Insert: Inserts new rows of data into a PostgreSQL table using document keys as columns.
-
PostgreSQL Update: Updates existing rows in a PostgreSQL table with the given properties.
-
PostgreSQL Delete: Deletes data from a PostgreSQL table with the given properties.
-
PostgreSQL Lookup: Looks up records in the target PostgreSQL table and returns a selected set of fields.
-
PostgreSQL Execute: Executes arbitrary SQL statements on a PostgreSQL database.
-
PostgreSQL Multi Execute: Executes one or more SQL write statements sequentially inside a single transaction.
-
PostgreSQL Bulk Load: Loads large amounts of data into PostgreSQL tables through a single bulk load operation.
-
PostgreSQL Bulk Upsert: Performs bulk insert or update operations into existing PostgreSQL tables.
-
PostgreSQL Table List: Outputs a list of tables in a PostgreSQL database.
-
PostgreSQL Vector Search: Performs vector similarity search in a PostgreSQL database.
Supported versions
This Snap Pack is tested against:
- PostgreSQL 9.2.10.0, 9.6.19, 10.12, and 10.1
- Amazon Aurora 1.17.2
- Azure SQL DB 9.6 and 10
- PostgreSQL JDBC driver version 42.7.2. Learn more about the JDBC driver upgrade.