Creating Models › Target Servers for Physical Models › Database Property Editors › PostgreSQL Physical Property Editors › PostgreSQL Support Summary › Define PostgreSQL Collations

Define PostgreSQL Collations

Use the PostgreSQL Collation Editor in a PostgreSQL physical model to specify the sort order and character classification behavior of data per-column, or per-operation.

To define a collation in PostgreSQL

1. In the Model Explorer, right-click Collations and click New.

   An instance of Collation is created.

2. Right-click the instance and click Properties.

   The PostgreSQL Collation Editor opens.

3. In the navigation grid, select the collation that you want to define and work with the following options:

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

   Name

   Specifies the name of the collation. Set the name of the collation in this field.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

4. On the PostgreSQL tab, work with the following options:

   Schema

   Specifies the schema for the collation. Select a schema from the drop-down list or click New to create one.

   Locale

   This is a shortcut for setting LC_COLLATE and LC_CTYPE at once. If you specify this, you cannot specify either of those parameters.

   LC_Collate

   Use the specified operating system locale for the LC_COLLATE locale category. The locale must be applicable to the current database encoding.

   LC_CType

   Use the specified operating system locale for the LC_CTYPE locale category. The locale must be applicable to the current database encoding.

   Copy Collation

   Specifies the name of an existing collation to copy. The new collation will have the same properties as the existing one, but it will be an independent object.

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 collation is defined and the PostgreSQL Collation Editor closes.

For more information, refer to PostgreSQL documentation.