Collation dialog to define a collation. A collation is an SQL schema
object that maps a SQL name to operating system locales. To create a collation,
you must have a CREATE privilege on the destination schema.
Collation dialog organizes the development of a collation through the
following dialog tabs:
SQL tab displays the
SQL code generated by dialog selections.
Use the fields in the
General tab to identify the collation:
Namefield to provide a name for the collation. The collation name must be unique within a schema. The name will be displayed in the Browser tree control.
Select the name of the owner from the drop-down listbox in the
Select the name of the schema in which the collation will reside from the drop-down listbox in the
Store notes about the collation in the
Definition tab to continue.
Use the fields in the
Definition tab to specify the operating system locale
Use the drop-down listbox next to
Copy collationto select the name of an existing collation to copy. The new collation will have the same properties as the existing one, but will be an independent object. If you choose to copy an existing collation, you cannot modify the collation properties displayed on this tab.
Localefield to specify a locale; a locale specifies language and language formatting characteristics. If you specify this, you cannot specify either of the following parameters. To view a list of locales supported by your Linux system use the command
LC_COLLATEfield to specify a locale with specified string sort order. The locale must be applicable to the current database encoding. (See CREATE DATABASE for details.)
LC_CTYPEfield to specify a locale with specified character classification. The locale must be applicable to the current database encoding. (See CREATE DATABASE for details.)
SQL tab to continue.
Your entries in the
Collation dialog generate a SQL command (see an example b
elow). Use the
SQL tab for review; revisit or switch tabs to make any changes
to the SQL command.
The following is an example of the sql command generated by user selections in
The example shown demonstrates creating a collation named
french that uses the
rules specified for the locale,
fr-BI-x-icu. The collation is owned by
Infobutton (i) to access online help. For more information about setting a locale, see Chapter 22.1 Locale Support of the PostgreSQL core documentation:
Savebutton to save work.
Cancelbutton to exit without saving work.
Resetbutton to restore configuration parameters.