v.1.1.54310New Feature
Added CREATE MATERIALIZED VIEW Query for Data Storage
Added the CREATE MATERIALIZED VIEW x TO y query (specifies an existing table for storing the data of a materialized view).Why it matters
This feature enables users to define a materialized view that writes its output directly into an existing table, rather than creating a new target table automatically. It provides more control over data storage, simplifies management of materialized views, and is useful when users want to consolidate or reuse storage tables for materialized views.How to use it
Use the statement CREATE MATERIALIZED VIEWx TO y AS SELECT ... where x is the name of the materialized view and y is the existing table into which the materialized view data will be stored. For example:CREATE MATERIALIZED VIEW <code>mv_name</code> TO <code>target_table</code> AS
<code>SELECT</code> ... <code>FROM</code> ...