Supported SQL Commands

Basic SQL

Data Description (DDL)

SQL Commands
Parses
Works
Notes and limitations

ALTER TABLE

βœ…

❌

CREATE DATABASE

βœ…

🟠

CREATE TABLE

βœ…

🟠

DROP DATABASE

βœ…

🟠

DROP TABLE

βœ…

🟠

Data Manipulation (DML)

SQL Commands
Parses
Works
Notes and limitations

CALL

βœ…

βœ…

DELETE

🟠

🟠

INSERT

🟠

🟠

SELECT

🟠

🟠

UPDATE

🟠

🟠

VALUES

🟠

🟠

All SQL

Access management statements

SQL Commands
Parses
Works
Notes and limitations

ALTER DEFAULT PRIVILEGES

βœ…

❌

ALTER GROUP

❌

❌

ALTER ROLE

❌

❌

ALTER USER

❌

❌

ALTER USER MAPPING

❌

❌

CREATE GROUP

🟠

❌

CREATE ROLE

🟠

❌

CREATE USER

🟠

❌

CREATE USER MAPPING

❌

❌

DROP GROUP

βœ…

❌

DROP ROLE

βœ…

❌

DROP USER

βœ…

❌

DROP USER MAPPING

❌

❌

GRANT

βœ…

❌

REASSIGN OWNED

❌

❌

REVOKE

βœ…

❌

Data definition statements

SQL Commands
Parses
Works
Notes and limitations

ALTER AGGREGATE

βœ…

❌

ALTER COLLATION

βœ…

❌

ALTER CONVERSION

βœ…

❌

ALTER DATABASE

βœ…

❌

ALTER DOMAIN

βœ…

❌

ALTER EVENT TRIGGER

❌

❌

ALTER EXTENSION

❌

❌

ALTER FOREIGN DATA WRAPPER

❌

❌

ALTER FOREIGN TABLE

❌

❌

ALTER FUNCTION

βœ…

❌

ALTER INDEX

βœ…

❌

ALTER LANGUAGE

βœ…

❌

ALTER LARGE OBJECT

❌

❌

ALTER MATERIALIZED VIEW

βœ…

❌

ALTER OPERATOR

❌

❌

ALTER OPERATOR CLASS

❌

❌

ALTER OPERATOR FAMILY

❌

❌

ALTER POLICY

❌

❌

ALTER PROCEDURE

βœ…

❌

ALTER PUBLICATION

❌

❌

ALTER ROUTINE

❌

❌

ALTER RULE

❌

❌

ALTER SCHEMA

βœ…

❌

ALTER SEQUENCE

βœ…

❌

ALTER SERVER

❌

❌

ALTER STATISTICS

❌

❌

ALTER SUBSCRIPTION

❌

❌

ALTER SYSTEM

❌

❌

ALTER TABLE

βœ…

❌

ALTER TABLESPACE

❌

❌

ALTER TEXT SEARCH CONFIGURATION

❌

❌

ALTER TEXT SEARCH DICTIONARY

❌

❌

ALTER TEXT SEARCH PARSER

❌

❌

ALTER TEXT SEARCH TEMPLATE

❌

❌

ALTER TRIGGER

βœ…

❌

ALTER TYPE

βœ…

❌

ALTER VIEW

βœ…

❌

COMMENT

βœ…

❌

CREATE ACCESS METHOD

❌

❌

CREATE AGGREGATE

βœ…

❌

CREATE CAST

❌

❌

CREATE COLLATION

❌

❌

CREATE CONVERSION

❌

❌

CREATE DATABASE

βœ…

🟠

CREATE DOMAIN

βœ…

❌

CREATE EVENT TRIGGER

❌

❌

CREATE EXTENSION

βœ…

❌

CREATE FOREIGN DATA WRAPPER

❌

❌

CREATE FOREIGN TABLE

❌

❌

CREATE FUNCTION

βœ…

❌

CREATE INDEX

βœ…

❌

CREATE LANGUAGE

βœ…

❌

CREATE MATERIALIZED VIEW

βœ…

❌

CREATE OPERATOR

❌

❌

CREATE OPERATOR CLASS

❌

❌

CREATE OPERATOR FAMILY

❌

❌

CREATE POLICY

❌

❌

CREATE PROCEDURE

βœ…

❌

CREATE PUBLICATION

❌

❌

CREATE RULE

❌

❌

CREATE SCHEMA

βœ…

❌

CREATE SEQUENCE

βœ…

❌

CREATE SERVER

❌

❌

CREATE STATISTICS

❌

❌

CREATE SUBSCRIPTION

❌

❌

CREATE TABLE

βœ…

🟠

CREATE TABLE ... PARTITION

βœ…

❌

PARTITIONs are parsed, but ignored

CREATE TABLESPACE

❌

❌

CREATE TEXT SEARCH CONFIGURATION

❌

❌

CREATE TEXT SEARCH DICTIONARY

❌

❌

CREATE TEXT SEARCH PARSER

❌

❌

CREATE TEXT SEARCH TEMPLATE

❌

❌

CREATE TRANSFORM

❌

❌

CREATE TRIGGER

βœ…

❌

CREATE TYPE

βœ…

❌

CREATE VIEW

βœ…

🟠

DROP ACCESS METHOD

❌

❌

DROP AGGREGATE

βœ…

❌

DROP CAST

❌

❌

DROP COLLATION

❌

❌

DROP CONVERSION

❌

❌

DROP DATABASE

βœ…

🟠

DROP DOMAIN

βœ…

❌

DROP EVENT TRIGGER

❌

❌

DROP EXTENSION

βœ…

❌

DROP FOREIGN DATA WRAPPER

❌

❌

DROP FOREIGN TABLE

❌

❌

DROP FUNCTION

βœ…

❌

DROP INDEX

βœ…

🟠

DROP LANGUAGE

βœ…

❌

DROP MATERIALIZED VIEW

βœ…

🟠

DROP OPERATOR

❌

❌

DROP OPERATOR CLASS

❌

❌

DROP OPERATOR FAMILY

❌

❌

DROP OWNED

❌

❌

DROP POLICY

❌

❌

DROP PROCEDURE

βœ…

❌

DROP PUBLICATION

❌

❌

DROP ROUTINE

❌

❌

DROP RULE

❌

❌

DROP SCHEMA

βœ…

❌

DROP SEQUENCE

βœ…

❌

DROP SERVER

❌

❌

DROP STATISTICS

❌

❌

DROP SUBSCRIPTION

❌

❌

DROP TABLE

βœ…

🟠

DROP TABLESPACE

❌

❌

DROP TEXT SEARCH CONFIGURATION

❌

❌

DROP TEXT SEARCH DICTIONARY

❌

❌

DROP TEXT SEARCH PARSER

❌

❌

DROP TEXT SEARCH TEMPLATE

❌

❌

DROP TRANSFORM

❌

❌

DROP TRIGGER

βœ…

🟠

DROP TYPE

βœ…

❌

DROP VIEW

βœ…

🟠

SECURITY LABEL

❌

❌

Data manipulation statements

SQL Commands
Parses
Works
Notes and limitations

CALL

βœ…

βœ…

CLOSE

❌

❌

CREATE TABLE AS

βœ…

❌

CLUSTER

❌

❌

COPY

❌

❌

DECLARE

❌

❌

DELETE

🟠

🟠

DO

❌

❌

FETCH

❌

❌

IMPORT FOREIGN SCHEMA

❌

❌

INSERT

🟠

🟠

LOAD

❌

❌

MERGE

❌

❌

MOVE

❌

❌

REFRESH MATERIALIZED VIEW

βœ…

❌

REINDEX

❌

❌

SELECT

🟠

🟠

SELECT INTO

❌

❌

TRUNCATE

🟠

🟠

UPDATE

🟠

🟠

VACUUM

❌

❌

VALUES

🟠

🟠

Prepared statements

SQL Commands
Parses
Works
Notes and limitations

DEALLOCATE

βœ…

❌

PREPARE

βœ…

❌

EXECUTE

βœ…

❌

Session management statements

SQL Commands
Parses
Works
Notes and limitations

DISCARD

🟠

❌

RESET

βœ…

❌

SET

βœ…

🟠

SET CONSTRAINTS

βœ…

❌

SET ROLE

βœ…

❌

SET SESSION AUTHORIZATION

βœ…

❌

SET TRANSACTION

🟠

❌

SHOW

βœ…

🟠

Transactional statements

SQL Commands
Parses
Works
Notes and limitations

ABORT

βœ…

βœ…

BEGIN

🟠

🟠

CHECKPOINT

❌

❌

COMMIT

βœ…

βœ…

COMMIT PREPARED

❌

❌

END

βœ…

βœ…

LISTEN

❌

❌

LOCK

❌

❌

NOTIFY

❌

❌

PREPARE TRANSACTION

❌

❌

RELEASE SAVEPOINT

βœ…

βœ…

ROLLBACK

βœ…

βœ…

ROLLBACK PREPARED

❌

❌

ROLLBACK TO SAVEPOINT

βœ…

βœ…

SAVEPOINT

βœ…

βœ…

START TRANSACTION

🟠

🟠

UNLISTEN

❌

❌

Utility statements

SQL Commands
Parses
Works
Notes and limitations

ANALYZE

❌

❌

EXPLAIN

❌

❌

Last updated