Creating VIEWs in Hyperstage

Hyperstage supports the creation of VIEWs. Note that the VIEW must contain Hyperstage optimized syntax, or the VIEW will be run in the PostgreSQL query engine.

Create VIEW Syntax

The syntax to create a VIEW is as follows:

CREATE
    [OR REPLACE]
    VIEW view_name [(column_list)]
    AS select_statement

A VIEW must contain unique column names. If you select two columns with the same name from separate tables, at least one must be aliased or the column list option must be used.

If the select statement of VIEW contains functionality that is not supported in the Hyperstage optimizer, then the VIEW will perform sub-optimally since it will always flip over to the PostgreSQL query engine.