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

Define PostgreSQL View Column Properties

In a model based on PostgreSQL target server, use the General tab in the View Column Editor to manage the domain parent, physical data type, and other properties for the selected column.

To define PostgreSQL view column properties

1. In the Model Explorer, right-click a view column and click Properties.

   The PostgreSQL View Column Editor opens.

2. Select the view from the View drop-down that contains the column that you want to define.
3. Select the column in the Navigation Grid that you want to define.

   Note: Click New on the toolbar to create a new column. Use the Enter filter text box to filter a very large list of columns to quickly locate the one that you want to define.

4. Click the General tab and work with the following options:

   Domain Parent

   Displays the current parent domain. Use the toolbar to sort the domain list or open the Domain Editor to work with domains.

   Name

   Displays the view column name. You can change the name in this field or specify one of the following naming options:

   Inherit

   Specifies to inherit the view column name from the domain.

   Override

   Specifies to override inheritance of the view column name.

   Harden

   Specifies to harden the view column name.

   Physical Data Type

   Displays the data type for the selected column.

5. Click the PostgreSQL tab and work with the following options:

   Collation

   Specifies an optional collation for the view column. Select a collation from the drop-down list or click New to create one.

   Default

   Specifies a default value for the view columns.

6. Work with the other tabs in the editor to access additional design features, for example:
   • Click the Expression tab and enter a view column expression, which is a user-defined expression that is stored as a view column.
   • Work with style sheets which are used to format the font and other graphical themes used in the display of the view in the Style tab.
7. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
8. (Optional) Click the Where Used tab to view where the object is used within the model.
9. (Optional) Click the UDP tab to work with user-defined properties for the object.
10. (Optional) Click the Notes tab to view and edit user notes.
11. (Optional) Click the Extended Notes tab to view or edit user notes.
12. Click Close.

    View column properties are defined and the PostgreSQL View Column Editor closes.

For more information on view column properties, refer to PostgreSQL documentation.