Help Center/
GaussDB(DWS)/
More Documents/
SQL Syntax Reference (ME-Abu Dhabi Region)/
Differences Between GaussDB(DWS) and PostgreSQL/
PostgreSQL Features Unsupported by GaussDB(DWS)
Updated on 2022-06-11 GMT+08:00
PostgreSQL Features Unsupported by GaussDB(DWS)
- Table inheritance
- Table creation features:
- Use REFERENCES reftable [ (refcolumn) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] to create a foreign key constraint for a table.
- Use EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) to create exclusion constraints for a table.
- Define or change the security tag of an object.
- User-defined C functions
- Create, modify, and delete operators.
- Create, modify, and delete operator classes.
- Create, modify, and delete operator families.
- Create, modify, and delete text search parsers.
- Create, modify, and delete text search templates.
- Create, modify, and delete collations.
- Create and delete rules.
- Register, modify, and delete languages.
- Create, modify, and delete domains.
- Define, modify, and delete the conversion of character set encoding.
- Define and delete casts.
- Define, modify, and delete user mapping.
- Generate a notification.
- Listen to a notification.
- Stop listening to a notification.
- Load or reload a shared library file.
- Release the session resources of a database.
- Move a cursor backward.
The following features are disabled in GaussDB(DWS) for separation of rights:
- TO PUBLIC of GRANT
- COPY FROM FILE and COPY TO FILE of COPY
Parent topic: Differences Between GaussDB(DWS) and PostgreSQL
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot