/DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="RULES-MATERIALIZEDVIEWS"
>38.3. Materialized Views</A
></H1
><P
>    Materialized views in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> use the
    rule system like views do, but persist the results in a table-like form.
    The main differences between:

</P><PRE
CLASS="PROGRAMLISTING"
>CREATE MATERIALIZED VIEW mymatview AS SELECT * FROM mytab;</PRE
><P>

    and:

</P><PRE
CLASS="PROGRAMLISTING"
>CREATE TABLE mymatview AS SELECT * FROM mytab;</PRE
><P