# phpman > man > CREATE_MATERIALIZED_VIEW(7)

CREATE MATERIALIZED [VIEW(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)        PostgreSQL 14.23 Documentation        CREATE MATERIALIZED [VIEW(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)



## NAME
       CREATE_MATERIALIZED_VIEW - define a new materialized view

## SYNOPSIS
       CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] _table_name_
           [ (_column_name_ [, ...] ) ]
           [ USING _method_ ]
           [ WITH ( _storage_parameter_ [= _value_] [, ... ] ) ]
           [ TABLESPACE _tablespace_name_ ]
           AS _query_
           [ WITH [ NO ] DATA ]

## DESCRIPTION
       **CREATE** **MATERIALIZED** **VIEW** 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 **WITH** **NO** **DATA** is used) and
       may be refreshed later using **REFRESH** **MATERIALIZED** **VIEW**.

       **CREATE** **MATERIALIZED** **VIEW** is similar to **CREATE** **TABLE** **AS**, 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.

       **CREATE** **MATERIALIZED** **VIEW** requires CREATE privilege on the schema used for the materialized
       view.

## PARAMETERS
       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.

       _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)](https://www.chedong.com/phpMan.php/man/TABLE/7/markdown)) documentation for more
           information. All parameters supported for CREATE TABLE are also supported for CREATE
           MATERIALIZED VIEW. See CREATE TABLE (**CREATE**___**[TABLE**(7)](https://www.chedong.com/phpMan.php/man/TABLE/7/markdown)) 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.

       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 **REFRESH** **MATERIALIZED** **VIEW** is used.

## COMPATIBILITY
       **CREATE** **MATERIALIZED** **VIEW** is a PostgreSQL extension.

## SEE ALSO
       ALTER MATERIALIZED VIEW (**ALTER**___**MATERIALIZED**___**[VIEW**(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)), CREATE TABLE AS (**CREATE**___**TABLE**___**[AS**(7)](https://www.chedong.com/phpMan.php/man/AS/7/markdown)),
       CREATE VIEW (**CREATE**___**[VIEW**(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)), DROP MATERIALIZED VIEW (**DROP**___**MATERIALIZED**___**[VIEW**(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)), REFRESH
       MATERIALIZED VIEW (**REFRESH**___**MATERIALIZED**___**[VIEW**(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown))



PostgreSQL 14.23                                2026                     CREATE MATERIALIZED [VIEW(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)