Citus SQL Language Reference¶
As Citus provides distributed functionality by extending PostgreSQL, it is compatible with PostgreSQL constructs. This means that users can use the tools and features that come with the rich and extensible PostgreSQL ecosystem for distributed tables created with Citus.
Citus supports all SQL queries on distributed tables, with only these exceptions:
- Correlated subqueries
- Recursive/modifying CTEs
- SELECT … FOR UPDATE
- Grouping sets
- Window functions that do not include the distribution column in PARTITION BY
To learn more about PostgreSQL and its features, you can visit the PostgreSQL documentation.
For a detailed reference of the PostgreSQL SQL command dialect (which can be used as is by Citus users), you can see the SQL Command Reference.