Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Chris Passion: "I tried 3 different programs before yours and none would be so handy and helpful. PostgreSQL Maestro works great and couldn't be easier to install".
J Canepa: "There is a lot of software out there for managing PostgreSQL. Yours is simply the best! Great product".

More

Add your opinion

PostgreSQL Maestro online Help

Prev Return to chapter overview Next

Materialized Views Editor

Materialized View Editor allows you to edit the existing view definition (view name and the SELECT statement it implements), browse and update the view data.
 

The basic principles of Object Editors in PostgreSQL Maestro are explained in a separate topic. Below you will find a description of editor tabs that are unique for the current object.

 

The Properties tab allows you to rename the view, change the definition, the owner, the tablespace and the comment of the view.

 

The Fields tab represents fields included in the materialized view. Use grid’s popup menu to describe or rename fields.

 

The Body area contains the query used to populate the view. To change the query, modify the SQL statement and use the Compile materialized view at the Navigation bar.

 

Is populated

This option id read-only and shows whether or not the materialized view is populated. If not, the materialized view is flagged as unscannable and cannot be queried until the Refresh materialized view is used.

 

The Data tab displays current view data represented as a grid (see Data View for details). The popup menu of this tab and the Data Management navigation bar allow you to export data, get SQL dump, set the value of the selected record to Null or to Now (for Date values). In tables with BLOB fields you can also call BLOB Editor to view and edit the BLOB fields.

 

Refreshing materialized views

To completely replace the contents of a materialized view,

open the popup menu of the editor tab or the view node at the Explorer tree,
use the Refresh materialized view command of the Data Management options group
check the Leave in unscannable state option in the Confirmation dialog to empty the materialized view and left in an unscannable state, or leave it unchecked to enforce the backing query execution to provide the view with fresh data.

 

 

See also: Create Materialized View Wizard



Prev Return to chapter overview Next