POSTGRESQL: CREATE COLLATION
top of page
CerebroSQL

PostgreSQL:  

CREATE COLLATION

Topic

CREATE COLLATION name (
[ LOCALE = locale, ]
[ LC_COLLATE = lc_collate, ]
[ LC_CTYPE = lc_ctype ]
)
CREATE COLLATION name FROM existing_collation

Example

CREATE COLLATION french (LOCALE = 'fr_FR.utf8');
CREATE COLLATION german FROM "de_DE";

bottom of page