all-things-risingwave
Is there a list of syntax/commands unique to RisingWave compared to PostgreSQL?
Chance Dinkins is interested in knowing if there is a list of syntax/commands unique to RisingWave compared to PostgreSQL, as he considers layering PRQL on top of RisingWave's SQL. Kexiang provides insights on the unique syntax and commands in RisingWave compared to PostgreSQL.
Ch
Chance Dinkins
Asked on Nov 29, 2023
- RisingWave's system is generally compatible with PostgreSQL, but there are some unique syntax and commands.
- The most important unique syntax in RisingWave compared to PostgreSQL is related to
Source
andSink
commands. - Materialized views in RisingWave are automatically updated, eliminating the need to run
REFRESH
commands manually. - There isn't a comprehensive list summarizing all the differences, as the syntax and system design in RisingWave is constantly evolving.
Dec 02, 2023Edited by