Supported SQL Commands
Basic SQL
Data Description (DDL)
ALTER TABLE
β
β
CREATE DATABASE
β
π
CREATE TABLE
β
π
DROP DATABASE
β
π
DROP TABLE
β
π
Data Manipulation (DML)
CALL
β
β
DELETE
π
π
INSERT
π
π
SELECT
π
π
UPDATE
π
π
VALUES
π
π
All SQL
Access management statements
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
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
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
DEALLOCATE
β
β
PREPARE
β
β
EXECUTE
β
β
Session management statements
DISCARD
π
β
RESET
β
β
SET
β
π
SET CONSTRAINTS
β
β
SET ROLE
β
β
SET SESSION AUTHORIZATION
β
β
SET TRANSACTION
π
β
SHOW
β
π
Transactional statements
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
ANALYZE
β
β
EXPLAIN
β
β
Last updated