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

Define View Sources

Use the From tab in the PostgreSQL View Editor to specify the source tables or views for a view. The source tables or views are those referenced by the 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 view sources

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

   The PostgreSQL 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.

   View sources are defined and the PostgreSQL View Editor closes.