Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Shafiq Far: "Just wanted to let you know that I think the SQL Maestro for Postgres is excellent. We've tried a variety over the past few years and none are even close to yours. Well done".
Andrew Maclean: "I am really quite impressed with the software. You and your people are doing a wonderful job. I actually have spent a while researching PostgreSQL admin/code generators and yours seems to fit our needs nicely. Your interface is beautiful".


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