Get started with a free trial today
Already have an account? Sign in
All versions for Stitch's PostgreSQL integration, including release and deprecation dates.
| Version | Status | Release | Deprecation | End of life (Sunset) |
| version 2 (latest) | Released | March 5, 2021 | ||
| version 1 | Deprecated | July 31, 2018 | June 2, 2021 | |
| version 15-10-2015 | Sunset | October 15, 2015 | September 6, 2019 | December 1, 2019 |
The five most recent updates made to the PostgreSQL integration. Refer to thePostgreSQL Integration Changelog for this integration's full history.
| Date | Type | Entry title |
| Jul 8, 2021 | New feature | PostgreSQL (v2) update: Google CloudSQL PostgreSQL now available! |
| Jun 2, 2021 | New feature | PostgreSQL (v2) update: Leaving beta! |
| Apr 19, 2021 | Removed | PostgreSQL (HP) (v2) integration: Removed support for Composite, Range and OID types |
| Mar 30, 2021 | Improvement | PostgreSQL (v2) update: Key-based Incremental Replication now available! |
| Mar 24, 2021 | New feature | New feature: Integration changelogs |
| View all entries in the PostgreSQL Integration Changelog | ||
In this section:
| PostgreSQL version 2 (latest) | PostgreSQL version 1 | |||
| STITCH | ||||
| Release status | Released on March 5, 2021 | Deprecated on June 2, 2021 | ||
| Supported by | ||||
| Stitch plan | Standard | Standard | ||
| Supported versions | 9.3+; 9.4+ for binlog | 9.3+; 9.4+ for binlog | ||
| API availability | Available | Not available | ||
| Singer GitHub repository | ||||
| CONNECTION METHODS | ||||
| SSH connections | Supported | Supported | ||
| SSL connections | Supported | Supported | ||
| REPLICATION SETTINGS | ||||
| Anchor Scheduling | Supported | Supported | ||
| Advanced Scheduling | Supported | Supported | ||
| Table-level reset | Supported | Supported | ||
| Configurable Replication Methods | Supported | Supported | ||
| REPLICATION METHODS | ||||
| Log-based Replication | Supported | Supported | ||
| Key-based Replication | Supported | Supported | ||
| Full Table Replication | Supported | Supported | ||
| DATA SELECTION | ||||
| Table selection | Supported | Supported | ||
| Column selection | Supported | Supported | ||
| View replication | Supported | Supported | ||
| Select all | Supported, with prerequisites | Supported, with prerequisites | ||
| TRANSPARENCY | ||||
| Extraction Logs | Supported | Supported | ||
| Loading Reports | Supported | Supported | ||
In the table below are the data types PostgreSQL integrations support and the Stitch data type it will map to, depending on the version of the integration being used:
Refer to theData typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.
Note: This table doesn't display info for versions that have been sunset.
| PostgreSQL version 2 (latest) | PostgreSQL version 1 | |
| ARRAY | ARRAY | ARRAY |
| BIGINT | INTEGER | INTEGER |
| BIGSERIAL | INTEGER | INTEGER |
| BIT | BOOLEAN | BOOLEAN |
| BIT VARYING | ||
| BOX | ||
| BYTEA | ||
| CHAR | STRING | STRING |
| CIDR | STRING | STRING |
| CIRCLE | ||
| CITEXT | STRING | STRING |
| COMPOSITE | ||
| DATE | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME |
| DECIMAL | NUMBER | NUMBER |
| DOUBLE | NUMBER | NUMBER |
| FLOAT | NUMBER | NUMBER |
| HSTORE | OBJECT | OBJECT |
| INET | STRING | STRING |
| INTEGER | INTEGER | INTEGER |
| INTERVAL | STRING | |
| IP | STRING | STRING |
| JSON | OBJECT | STRING |
| JSONB | OBJECT | STRING |
| LINE | ||
| LONGNVARCHAR | STRING | STRING |
| LONGVARCHAR | STRING | STRING |
| LSEG | ||
| MACADDR | STRING | STRING |
| MONEY | STRING | STRING |
| NCHAR | STRING | STRING |
| NUMERIC | NUMBER | NUMBER |
| NVARCHAR | STRING | STRING |
| OID | ||
| PATH | ||
| PG_LSN | ||
| POINT | ||
| POLYGON | ||
| RANGE | ||
| REAL | DOUBLE | NUMBER |
| REGCLASS | ||
| REGCONFIG | ||
| REGDICTIONARY | ||
| REGOPER | ||
| REGOPERATOR | ||
| REGPROC | ||
| REGPROCEDURE | ||
| REGTYPE | ||
| SERIAL | INTEGER | INTEGER |
| SMALLINT | INTEGER | INTEGER |
| SMALLSERIAL | INTEGER | INTEGER |
| TIME | STRING | STRING |
| TIMESTAMP | STRING , formatted as DATE-TIME | STRING , formatted as DATE-TIME |
| TINYINT | INTEGER | INTEGER |
| TSQUERY | ||
| TSVECTOR | ||
| TXID_SNAPSHOT | ||
| UUID | STRING | STRING |
| VARCHAR | STRING | STRING |
| XML |
| Related | Troubleshooting |
Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.