Understanding PostgreSQL compatibility

Aurora DSQL is PostgreSQL compatible, which means that it provides identical behavior for most supported features, identical query results for all SQL features, and supports many popular PostgreSQL drivers and tools with minor configuration changes. Supported SQL expressions return identical data in query results, including sort order, scale and precision for numeric operations, and equivalence for string operations. With a few documented exceptions, such as synchronous replication, no-lock concurrency control, and asynchronous DDL execution, Aurora DSQL behaves comparably to PostgreSQL.

Aurora DSQL supports core relational features like ACID transactions, secondary indexes, joins, insert, and updates. See Supported SQL expressions for an overview of supported SQL features.

Aurora DSQL doesn't support all PostgreSQL features. For more information, see Unsupported PostgreSQL features.

Aurora DSQL uses standard PostgreSQL drivers and supports 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.