

Creating Models › Target Servers for Physical Models › Database Property Editors › PostgreSQL Physical Property Editors › PostgreSQL Support Summary › Define PostgreSQL Materialized Views › Change the SQL Code for a Materialized View
Change the SQL Code for a Materialized View
Use the SQL tab in the PostgreSQL Materialized View Editor to view and change the SQL code that is maintained for a materialized view.
To change the SQL code for a materialized view
- Right-click the materialized view for which you want to change the SQL code and click Properties.
The PostgreSQL Materialized View Editor opens.
- Click the SQL tab and click the
button.
The Materialized View SQL dialog opens.
- Add or edit the SQL code as needed. Work with the options on the toolbar to save, print, find and replace, and cut, copy, or paste text.
- Click Close.
SQL code is changed for the selected materialized view and the PostgreSQL Materialized View Editor closes.
Copyright © 2017 erwin Inc.
All rights reserved.
 
|
|