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:
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.