The view collations contains the collations available in the current database.
collations
Column Type
Description
collation_catalog sql_identifier
collation_catalog
sql_identifier
Name of the database containing the collation (always the current database)
collation_schema sql_identifier
collation_schema
Name of the schema containing the collation
collation_name sql_identifier
collation_name
Name of the default collation
pad_attribute character_data
pad_attribute
character_data
Always NO PAD (The alternative PAD SPACE is not supported by PostgreSQL.)
NO PAD
PAD SPACE
Was this helpful?
