Supported and unsupported Data Manipulation Language (DML) and query processing SQL commands
The following table lists the DML commands that are supported and not supported by Aurora PostgreSQL Limitless Database, with references to limitations or more information.
| Command | Supported? | Limitations or more information |
|---|---|---|
| ABORT | Yes | None |
| ANALYZE | Yes | ANALYZE |
| BEGIN | Yes | None |
| CALL | Yes | None |
| CHECKPOINT | Yes | None |
| CLOSE | Yes | None |
| CLUSTER | Yes | CLUSTER |
| COMMIT | Yes | None |
| COMMIT PREPARED | No | Not applicable |
| COPY | Yes | None |
| DEALLOCATE | Yes | None |
| DECLARE | Yes | None |
| DELETE | Yes | None |
| DISCARD | No | Not applicable |
| DO | Yes | None |
| END | Yes | None |
| EXECUTE | Yes | None |
| EXPLAIN | Yes | EXPLAIN |
| FETCH | Yes | None |
| IMPORT FOREIGN SCHEMA | No | Not applicable |
| INSERT | Yes | INSERT |
| LISTEN | No | Not applicable |
| LOCK | Yes | None |
| MERGE | No | Not applicable |
| MOVE | Yes | None |
| NOTIFY | No | Not applicable |
| OPEN | Yes | None |
| PREPARE | Yes | None |
| PREPARE TRANSACTION | No | Not applicable |
| REFRESH MATERIALIZED VIEW | No | Not applicable |
| REINDEX | No | Not applicable |
| RELEASE SAVEPOINT | Yes | None |
| ROLLBACK | Yes | None |
| ROLLBACK PREPARED | No | Not applicable |
| ROLLBACK TO SAVEPOINT | Yes | None |
| SAVEPOINT | Yes | None |
| SELECT | Yes | None |
| SELECT INTO | Yes | None |
| SHOW | Yes | None |
| START TRANSACTION | Yes | None |
| UNLISTEN | No | None |
| UPDATE | Yes | UPDATE |
| UPDATE … WHERE CURRENT OF | No | Not applicable |
| VACUUM | Yes | VACUUM |
| VALUES | Yes | None |
