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

Subscribe to our news:
Partners
Testimonials
Patric Michael: "Thank you for a wonderful product, and all the hard work you've obviously taken".
Daryl Joubert: "I am evaluating your PostgreSQL Maestro product for purchase by my company and thus far I am very impressed! I really like the easy, intuitive and productive user interface and feature set. I am also evaluating a number of other products for PostgreSQL database design and maintenence but thus far SQLMaestro stands head and shoulders above the rest".

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