CREATE_MATERIALIZED_VIEW - define a new materialized view

CREATEMATERIALIZEDVIEW is a PostgreSQL extension.

CREATEMATERIALIZEDVIEW defines a materialized view of a query. The query is executed and used to
       populate the view at the time the command is issued (unless WITHNODATA is used) and may be refreshed
       later using REFRESHMATERIALIZEDVIEW.

       CREATEMATERIALIZEDVIEW is similar to CREATETABLEAS, except that it also remembers the query used to
       initialize the view, so that it can be refreshed later upon demand. A materialized view has many of the
       same properties as a table, but there is no support for temporary materialized views.

       CREATEMATERIALIZEDVIEW requires CREATE privilege on the schema used for the materialized view.

       CREATE_MATERIALIZED_VIEW - define a new materialized view

       IF NOT EXISTS
           Do not throw an error if a materialized view with the same name already exists. A notice is issued in
           this case. Note that there is no guarantee that the existing materialized view is anything like the
           one that would have been created.

       table_name
           The name (optionally schema-qualified) of the materialized view to be created. The name must be
           distinct from the name of any other relation (table, sequence, index, view, materialized view, or
           foreign table) in the same schema.

       column_name
           The name of a column in the new materialized view. If column names are not provided, they are taken
           from the output column names of the query.

       USING method
           This optional clause specifies the table access method to use to store the contents for the new
           materialized view; the method needs be an access method of type TABLE. See Chapter 61 for more
           information. If this option is not specified, the default table access method is chosen for the new
           materialized view. See default_table_access_method for more information.

       WITH ( storage_parameter [= value] [, ... ] )
           This clause specifies optional storage parameters for the new materialized view; see Storage
           Parameters in the CREATE TABLE (CREATE_TABLE(7)) documentation for more information. All parameters
           supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW. See CREATE TABLE
           (CREATE_TABLE(7)) for more information.

       TABLESPACE tablespace_name
           The tablespace_name is the name of the tablespace in which the new materialized view is to be
           created. If not specified, default_tablespace is consulted.

       query
           A SELECT, TABLE, or VALUES command. This query will run within a security-restricted operation; in
           particular, calls to functions that themselves create temporary tables will fail. Also, while the
           query is running, the search_path is temporarily changed to pg_catalog, pg_temp.

       WITH [ NO ] DATA
           This clause specifies whether or not the materialized view should be populated at creation time. If
           not, the materialized view will be flagged as unscannable and cannot be queried until REFRESHMATERIALIZEDVIEW is used.

       ALTER MATERIALIZED VIEW (ALTER_MATERIALIZED_VIEW(7)), CREATE TABLE AS (CREATE_TABLE_AS(7)), CREATE VIEW
       (CREATE_VIEW(7)), DROP MATERIALIZED VIEW (DROP_MATERIALIZED_VIEW(7)), REFRESH MATERIALIZED VIEW
       (REFRESH_MATERIALIZED_VIEW(7))

PostgreSQL 17.5                                       2025                           CREATEMATERIALIZEDVIEW(7)

       CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name
           [ (column_name [, ...] ) ]
           [ USING method ]
           [ WITH ( storage_parameter [= value] [, ... ] ) ]
           [ TABLESPACE tablespace_name ]
           AS query
           [ WITH [ NO ] DATA ]