PostgreSQL Snap Pack
This page is no longer maintained (May 13, 2026). For the most current information, go to https://docs.snaplogic.com/snaps/sp-postgresql/sp-postgresql-about.html
In this article
Overview
Use the PostgreSQL Snap Pack to connect to your PostgreSQL database and achieve read and write access to its objects.
Use Snaps in this Snap Pack to:
Lookup records in the target table and returns a selected set of fields.
Fetch data from a database.
Execute SQL statements to delete, update, or insert data into a specified table.
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.
In this Section
- FAQs for PostgreSQL JDBC driver from v9.4.1207 to v42.7.2
- Configuring PostgreSQL Accounts
- PostgreSQL - Bulk Load
- PostgreSQL - Bulk Upsert
- PostgreSQL - Delete
- PostgreSQL - Execute
- PostgreSQL Multi Execute
- PostgreSQL - Insert
- PostgreSQL - Lookup
- PostgreSQL - Select
- PostgreSQL - Table List
- PostgreSQL - Update
- PostgreSQL - Vector Search