Amazon PostgreSQL RDS

Identify your version

To identify the version of the Amazon PostgreSQL RDS integration you're using:

1. Sign into your Stitch account.
2. On the Stitch Dashboard, click the Amazon PostgreSQL RDS integration you want to check.
3. Click the Extraction Logs tab:
• If you see a list of extraction logs, the integration's version is v1.0.
• If you see No logs available for this integration yet., the integration's version is v15-10-2015.

• version 1.0 (latest)
  Setup | Replication
• version 15-10-2015
  Setup | Replication

---

Version history

In this section:

• Overview - All versions for Stitch's Amazon PostgreSQL RDS integration, including release and deprecation dates.
• Changelog - Details about updates to Stitch's Amazon PostgreSQL RDS integration, including new/deprecated versions, schema changes, new data availability, etc.

• Overview
• Changelog

---

Amazon PostgreSQL RDS version features

In this section:

• Supported features

• Data types

Amazon PostgreSQL RDS supported features

	Amazon PostgreSQL RDS version 1.0 (latest)	Amazon PostgreSQL RDS version 15-10-2015
CONNECTION METHODS
SSH Connections	Supported	Supported
SSL Connections	Supported	Supported
REPLICATION SETTINGS
Anchor Scheduling	Supported	Unsupported
Advanced Scheduling	Supported	Unsupported
Table-level Reset	Supported	Supported
Configurable Replication Methods	Supported	Supported
REPLICATION METHODS
Log-based Replication	Supported	Unsupported
Key-based Replication	Supported	Supported
Full Table Replication	Supported	Supported
DATA SELECTION
Table Selection	Supported	Supported
Column Selection	Supported	Supported
View Replication	Supported	Supported
TRANSPARENCY
Extraction Logs	Supported	Unsupported
Loading Reports	Supported	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.0 (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	ARRAY	STRING
JSONB	ARRAY	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 , formatted as DATE-TIME	STRING , formatted as DATE-TIME
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.