Browse categories
Random entry
Blog
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)
Predefined roles

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

CREATE COLLATION

An SQL command for defining a collation

CREATE COLLATION is a DDL command for defining a collation.

CREATE COLLATION was added in PostgreSQL 9.1.

Change history

PostgreSQL 12
- option DETERMINISTIC added (commit 5e1963fb)
PostgreSQL 10
- options PROVIDER and VERSION added (commit eccfef81))
- IF NOT EXISTS syntax added (commit 6d16ecc6)
PostgreSQL 9.1
- added (commit b313bca0)

References

PostgreSQL documentation: CREATE COLLATION

Categories

See also

ALTER COLLATION, DROP COLLATION, pg_import_system_collations(), pg_collation