Previous Topic: Define User Defined SQL for a Materialized ViewNext Topic: Define the Style for a Table, View, or Column

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

  1. Right-click the materialized view for which you want to change the SQL code and click Properties.

    The PostgreSQL Materialized View Editor opens.

  2. Click the SQL tab and click the Text Editor Icon button.

    The Materialized View SQL dialog opens.

  3. 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.
  4. Click Close.

    SQL code is changed for the selected materialized view and the PostgreSQL Materialized View Editor closes.