Amazon PostgreSQL RDS

Identify your version

• RELEASED (LATEST)
  version 1 Setup | Replication
• SUNSET
  version 15-10-2015 Setup | Replication

---

Version history

All versions for Stitch's Amazon PostgreSQL RDS integration, including release and deprecation dates.

Version	Status	Release date	Deprecation date	End of life (Sunset)
version 1 (latest)	Released	July 31, 2018
version 15-10-2015	Sunset	October 15, 2015	September 6, 2019	December 1, 2019

---

Amazon PostgreSQL RDS version features

In this section:

• Supported features

• Data types

Amazon PostgreSQL RDS version comparison

	Amazon PostgreSQL RDS version 1 (latest)
STITCH
Release status	Released on July 31, 2018
Supported by	Stitch
Stitch plan	Standard
Supported versions	9.3+; 9.4+ for binlog
API availability	Available
Singer GitHub repository	singer-io/tap-postgres
CONNECTION METHODS
SSH connections	Supported
SSL connections	Supported
REPLICATION SETTINGS
Anchor Scheduling	Supported
Advanced Scheduling	Supported
Table-level reset	Supported
Configurable Replication Methods	Supported
REPLICATION METHODS
Log-based Replication	Supported
Key-based Replication	Supported
Full Table Replication	Supported
DATA SELECTION
Table selection	Supported
Column selection	Supported
View replication	Supported
Select all	Supported, with prerequisites
TRANSPARENCY
Extraction Logs	Supported
Loading Reports	Supported

Data types

In the table below are the data types Amazon PostgreSQL RDS 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.

	Amazon PostgreSQL RDS version 1 (latest)	Amazon PostgreSQL RDS version 15-10-2015
ARRAY	ARRAY	STRING
BIGINT	INTEGER	INTEGER
BIT	BOOLEAN	BOOLEAN
CHAR	STRING	STRING
CIDR	STRING	UNSUPPORTED
CITEXT	STRING	UNSUPPORTED
DATE	STRING , formatted as DATE-TIME	STRING , formatted as DATE-TIME
DECIMAL	NUMBER	NUMBER
DOUBLE	NUMBER	NUMBER
FLOAT	NUMBER	NUMBER
HSTORE	OBJECT	STRING
INET	STRING	STRING
INTEGER	INTEGER	INTEGER
IP	STRING	UNSUPPORTED
JSON	STRING	STRING
JSONB	STRING	STRING
LONGNVARCHAR	STRING	STRING
LONGVARCHAR	STRING	STRING
MACADDR	STRING	UNSUPPORTED
MONEY	STRING	UNSUPPORTED
NCHAR	STRING	STRING
NUMERIC	NUMBER	NUMBER
NVARCHAR	STRING	STRING
REAL	NUMBER	NUMBER
SMALLINT	INTEGER	INTEGER
TIME	STRING	STRING
TIMESTAMP	STRING , formatted as DATE-TIME	STRING , formatted as DATE-TIME
TINYINT	INTEGER	INTEGER
UUID	STRING	STRING
VARCHAR	STRING	STRING

Related	Troubleshooting
Destination & Integration Compatibility Replication Scheduling Replication Methods Replication Keys	PostgreSQL Data Types Stored as Strings PostgreSQL Read Replicas and Slow Replication Database Connection Errors Understanding & Reducing Your Usage Re-Authorizing Integrations Replication Issues

---

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.