Creating Models › Target Servers for Physical Models › Database Property Editors › PostgreSQL Physical Property Editors › PostgreSQL Support Summary › Define PostgreSQL Materialized Views › Change the Columns Referenced by a Materialized View

Change the Columns Referenced by a Materialized View

Use the Select tab in the PostgreSQL Materialized View Editor to change the columns referenced by a materialized view.

To change the columns referenced by a materialized view

1. Right-click the materialized view instance in the Model Explorer for which you want to change its columns and click Properties.

   The PostgreSQL Materialized View Editor opens.

2. Click the Select tab.
3. Double-click a column in the Available Tables and Views list to move it to the Columns list and add it to the view. Double-click a column in the Columns list to move it to the Available Tables and Views list and remove it from the view.
4. Click Close.

   Materialized view column references are changed and the PostgreSQL Materialized View Editor closes.