Hologres supports the PostgreSQL statements. These statements can be used to create, query, and update tables and schemas. It also includes further support for other PostgreSQL statements. This topic describes these PostgreSQL statements.
The following table lists the PostgreSQL statements supported by Hologres. For more
information, see PostgreSQL 11.9 Documentation.
PostgreSQL statement | Description |
---|---|
ALTER TABLE | Hologres supports only the following commands of the ALTER TABLE statement:
|
ALTER ROLE | N/A |
ANALYZE | N/A |
BEGIN | The BEGIN statement requires a Data Definition Language (DDL) statement.
|
COMMIT | The COMMIT statement requires a DDL statement.
|
CREATE DATABASE | N/A |
CREATE EXTENSION | N/A |
CREATE FOREIGN DATA WRAPPER | N/A |
CREATE FOREIGN TABLE | Hologres supports only foreign tables of MaxCompute. |
CREATE GROUP | N/A |
CREATE SERVER | N/A |
CREATE TABLE | Hologres does not support the following commands of the CREATE TABLE statement:
Hologres supports only list partitions. You can specify only a list of discrete values for the partitioning key in the description for each partition. |
CREATE VIEW | N/A |
CREATE USER | N/A |
CREATE USER MAPPING | N/A |
DROP DATABASE | N/A |
DROP FOREIGN DATA WRAPPER | N/A |
DROP FOREIGN TABLE | N/A |
DROP GROUP | N/A |
DROP OWNED | N/A |
DROP POLICY | N/A |
DROP ROLE | N/A |
DROP SERVER | N/A |
DROP TABLE | N/A |
DROP USER | N/A |
DROP USER MAPPING | N/A |
END | The END statement requires a DDL statement.
|
EXPLAIN | N/A |
INSERT | N/A |
ROLLBACK | N/A |
SELECT | Hologres does not support all the commands of the SELECT statement: The following commands are unsupported:
|
SET | Hologres supports SET commands. However, these commands do not apply and may be canceled. |
SET ROLE | N/A |
START TRANSACTION | N/A |