On this page

Show all

Help Center/ GaussDB(DWS)/ Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs/ PG_COLLATION

PG_COLLATION

Updated on 2024-09-30 GMT+08:00

View PDF

PG_COLLATION records the available collations, which are essentially mappings from an SQL name to operating system locale categories.

**Table 1** PG_COLLATION columns
Name	Type	Reference	Description
oid	oid	N/A	Row identifier (hidden attribute; displayed only when explicitly selected)
collname	name	N/A	Collation name (unique per namespace and encoding)
collnamespace	oid	PG_NAMESPACE.oid	OID of the namespace that contains this collation
collowner	oid	PG_AUTHID.oid	Owner of the collation
collencoding	integer	N/A	Encoding in which the collation is applicable, or -1 if it works for any encoding
collcollate	name	N/A	LC_COLLATE for this collation object
collctype	name	N/A	LC_CTYPE for this collation object

Parent topic: System Catalogs

Previous topic: PG_CLASS

Next topic: PG_CONSTRAINT

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback