Amazon Aurora DSQL is provided as a Preview service.
To learn more, see Betas and Previews
PostgreSQL compatibility with Aurora DSQL
Aurora DSQL is PostgreSQL-compatible. Thus, for most supported features, Aurora DSQL and PostgreSQL provide identical behavior. For example, Aurora DSQL provides PostgreSQL compatibility as follows:
-
Identical query results for all SQL features. Supported SQL expressions return identical data in query results, including sort order, scale and precision for numeric operations, and equivalence for string operations.
-
Support for standard PostgreSQL drivers and common PostgreSQL-compatible tools, with some configuration changes. To see a list of supported tools, see Utilities, tools, and sample code. To see code examples and other developer-related topics, see Programming with Aurora DSQL.
-
Support for core relational database features such as ACID transactions, secondary indexes, joins, insert, and updates. For an overview of supported SQL features, see Supported SQL expressions.
Although Aurora DSQL maintains high PostgreSQL compatibility, there are some important differences in advanced features and operational aspects. For more information, see Unsupported PostgreSQL features.
Topics
