Other SQL Commands¶
Hologres is compatible with PostgreSQL. In addition to table creation, schema change, DML, and query, Hologres supports other SQL commands. The following table lists other supported SQL commands. You can find usage description and examples from PostgreSQL official documentation:
Command | Supported? | Note |
---|---|---|
ALTER ROLE | YES | None |
ANALYZE | YES | None |
BEGIN | YES | Only valid for DDL |
COMMIT | YES | Only valid for DDL |
CREATE DATABASE | YES | None |
CREATE EXTENSION | YES | None |
CREATE FOREIGN DATA WRAPPER | YES | None |
CREATE FOREIGN TABLE | YES | Only support MaxCompute |
CREATE GROUP | YES | None |
CREATE SERVER | YES | None |
CREATE TABLE | YES | Only support partial PostgreSQL functionality(For example,the only supported partition type is list,and partition list only can have one value with string data type)。 The following is unsupported:UNLOGGEDTEMPIF NOT EXISTSLIKECHECKDEFAULTGENERATEDUNIQUEEXCLUDEFOREIGN KEYDEFERRABLEWITH OIDSGLOBAL/LOCAL |
CREATE VIEW | YES | None |
CREATE USER | YES | None |
CREATE USER MAPPING | YES | None |
DROP DATABASE | YES | None |
DROP FOREIGN DATA WRAPPER | YES | None |
DROP FOREIGN TABLE | YES | None |
DROP GROUP | YES | None |
DROP OWNED | YES | None |
DROP POLICY | YES | None |
DROP ROLE | YES | None |
DROP SERVER | YES | None |
DROP TABLE | YES | None |
DROP USER | YES | None |
DROP USER MAPPING | YES | None |
END | YES | Only can be used with DDL statements |
EXPLAIN | YES | None |
INSERT | YES | None |
ROLLBACK | YES | None |
SELECT | YES | Partial functionality support. The following is unsupported:CUBE/GROUPING SET/ROLL UPRECURSIVENULL FIRST/LASTINTERSECT/EXCEPTTABLESAMPLELockingONLY |
SET | YES | Set some Postgres parameter might have no effects |
SET ROLE | YES | None |
START TRANSACTION | YES | None |