Supported SQL for Aurora DSQL
Aurora DSQL supports a wide range of core PostgreSQL SQL features. In the following sections, you can learn about general PostgreSQL expression support. This list is not exhaustive.
SELECT
command
Aurora DSQL supports the following clauses of the SELECT
command.
Primary clause | Supported clauses |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Data Definition Language (DDL)
Aurora DSQL supports the following PostgreSQL DDL commands.
Command | Primary Clause | Supported Clauses |
---|---|---|
|
|
For information about the supported syntax of the |
|
|
For information about the supported syntax of the |
|
|
|
|
|
You can use this command with the following parameters: For information about the supported syntax of the |
|
|
|
|
|
For more information about the supported syntax of the |
ALTER |
VIEW |
For information about the supported syntax of the |
DROP |
VIEW |
For information about the supported syntax of the DROP VIEW
command, see DROP VIEW. |
|
|
|
|
|
|
|
|
Data Manipulation Language (DML)
Aurora DSQL supports the following PostgreSQL DML commands.
Command | Primary clause | Supported clauses |
---|---|---|
|
|
SELECT |
|
|
|
DELETE |
FROM |
USING , WHERE |
Data Control Language (DCL)
Aurora DSQL supports the following PostgreSQL DCL commands.
Command | Supported clauses |
---|---|
|
|
|
|
Transaction Control Language (TCL)
Aurora DSQL supports the following PostgreSQL TCL commands.
Command | Supported clauses |
---|---|
|
|
|
[ [ |
Utility commands
Aurora DSQL supports the following PostgreSQL utility commands:
-
EXPLAIN
-
ANALYZE
(relation name only)