Skip to main content Skip to complementary content
Already have an account? Sign in

PostgreSQL

Last updated: 9/15/2026

Identify your version

PostgreSQL updates

PostgreSQL version history

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

PostgreSQL changelog

The five most recent updates made to the PostgreSQL integration. Refer to the PostgreSQL Integration Changelog for this integration's full history.

PostgreSQL version features

In this section:

PostgreSQL version comparison

PostgreSQL
version 2
(latest)
PostgreSQL
version 1
STITCH
Release status

Released on March 5, 2021

Deprecated on June 2, 2021

Supported by

Stitch

Stitch

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

singer-io/tap-postgres

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

Data types

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:

  • indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
  • indicates that the data type is supported, but there is additional information you should know. Hover over the icon to view a tooltip with the information.
  • indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
  • indicates that the data type isn't supported. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.

Refer to the Data 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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!