CREATE_MATERIALIZED_VIEW man page on Alpinelinux

Man page or keyword search:  
man Server   18016 pages
apropos Keyword Search (all sections)
Output format
Alpinelinux logo
[printable version]

CREATE MATERIALIZED VIEWPostgreSQL 9.3.4 DocumentatCREATE MATERIALIZED VIEW(7)

NAME
       CREATE_MATERIALIZED_VIEW - define a new materialized view

SYNOPSIS
       CREATE MATERIALIZED VIEW table_name
	   [ (column_name [, ...] ) ]
	   [ 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 or automatic generation of OIDs.

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

       WITH ( storage_parameter [= value] [, ... ] )
	   This clause specifies optional storage parameters for the new
	   materialized view; see Storage Parameters for more information. All
	   parameters supported for CREATE TABLE are also supported for CREATE
	   MATERIALIZED VIEW with the exception of OIDS. 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(7), TABLE, or VALUES(7) 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)), 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 9.3.4		     2014	   CREATE MATERIALIZED VIEW(7)
[top]

List of man pages available for Alpinelinux

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net