Creating Models › Creating a Physical Model › Columns › Defining Table Column Properties for Target Databases › Define PostgreSQL Table Column Properties

Define PostgreSQL Table Column Properties

In a model based on the PostgreSQL target server, use the PostgreSQL tab in the Table Column Editor to manage the data type, null option, and other properties for the selected column.

Note: The options described here are the basic options available for most physical data types. These options may vary depending on the physical data type you assign to the table column. Refer to the PostgreSQL documentation for more information on using these properties.

To define PostgreSQL table column properties

1. Right-click a table column in the Model Explorer and click Properties.

   The PostgreSQL Table Column Editor opens.

2. Select the table from the Table drop-down that contains the column that you want to define.
3. Select the column in the Navigation Grid that you want to define and work with the following options:

   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.

   Physical Name

   Specifies the physical name of the column. You can change the name of the column in this field.

   Domain Parent

   Specifies the domain parent of the column. Select the domain parent from the drop-down list.

   Physical Data Type

   Specifies the physical data type for the selected column. Select a physical data type from the drop-down list.

   Primary Key

   Specifies to designate the selected column as a primary key column. Select the check box to enable this option.

   Physical Only

   Specifies whether the column is suppressed from a logical model (as an attribute) and appears in a physical model only.

   Foreign Key

   Specifies to designate the selected column as a foreign key column. Select the check box to enable this option.

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

   Collation

   Specifies a collation that is to be assigned to the column (which must be of a collatable data type). If not specified, the column data type's default collation is used. Select an existing collation from the drop-down list or click New to create one.

   Default

   Specifies a default data value for the column. The value is any variable-free expression. The data type of the default expression must match the data type of the column.

   Attribute Statistics

   Storage Strategy

   Specifies the storage mode for the column. Select one of the following:

   Plain

   Used for fixed-length values such as integer and is in-line, uncompressed.

   External

   Used for for external, uncompressed data.

   Extended

   Used for external, compressed data.

   Main

   Used for for in-line, compressible data.

   Of Type

   Creates a typed column, which takes its structure from the specified composite type. A typed column is tied to its type. Select an existing user-defined type from the drop-down list or click New to create one.

5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
6. (Optional) Click the Where Used tab to view where the object is used within the model.
7. (Optional) Click the UDP tab to work with user-defined properties for the object.
8. (Optional) Click the Notes tab to view and edit user notes.
9. (Optional) Click the Extended Notes tab to view or edit user notes.
10. Click Close.

    The table column properties are defined and the PostgreSQL Table Column Editor closes.