Creating Models › Target Servers for Physical Models › Database Property Editors › PostgreSQL Physical Property Editors › PostgreSQL Support Summary › Define PostgreSQL Materialized Views › Define Materialized View Sources

Define Materialized View Sources

Use the From tab in the PostgreSQL Materialized View Editor to specify the source tables or views for a materialized view. The source tables or views are those referenced by the materialized view. You can also specify the order of the tables or views. For each source table or view, you can specify an alias name.

To define materialized view sources

1. Right-click the materialized view instance in the Model Explorer and click Properties.

   The PostgreSQL Materialized View Editor opens.

2. Click the From tab and work with the following options:

   Available Tables and Views

   Displays the names of the tables or views in the current model. Double-click a table or view in this list to move it to the From list to include its columns in the selected view.

   Note: Selections made here determine the available tables and views that can be referenced by a view in the Select tab.

   From

   Displays the names of all the source tables and views for the selected view. Double-click a table or view in this list to remove the columns from the selected view and move it to the Available Tables and Views list. Use the up and down arrows to move a selected table or view up or down one position in the list.

   Alias

   Lets you enter an alternative name for the selected source table or view.

   Note: This option is available only when you select a table or view in the From list. An alias is typically a new name that is more appropriate in the context of the view.

3. Click Close.

   Materialized View sources are defined and the PostgreSQL Materialzed View Editor closes.