Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
Use the 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.
The Collation dialog organizes the development of a collation through the
following dialog tabs: General and Definition. The SQL tab displays the
SQL code generated by dialog selections.
Use the fields in the General tab to identify the collation:
Click the Definition tab to continue.
Use the fields in the Definition tab to specify the operating system locale
Click the 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 Collation dialog:
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
Click the Info button (i) to access online help. For more information about
setting a locale, see Chapter 22.1 Locale Support of the PostgreSQL core
Click the Save button to save work.
Click the Cancel button to exit without saving work.
Click the Reset button to restore configuration parameters.