↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Search PostgreSQL documentation

PG 18 · Browse by category, or enter a name or keyword

Category index53
BIG5Collations & EncodingsWikiCollations & Encodings · Client-only encodingsBig Five Client-only encodings Encoding BIG5 Encoding id 36 Language Traditional Chinese Server? No Icu? No Bytes/char 1-2 Bytes/char 1–2 builtinCollations & EncodingsWikiCollations & Encodings · Collation provider identitiescollation provider. Collation provider identities Provider builtin Catalog code b Scope Source provider identity; installation/build availability is separate CCollations & EncodingsWikiCollations & Encodings · Bootstrap collationsstandard C collation Bootstrap collations Collname C Collprovider c Collencoding -1 Collcollate C Collctype C Collversion _null_ Collisdeterministic t Colliculocale _null_ Collicurules _nul… defaultCollations & EncodingsWikiCollations & Encodings · Bootstrap collationsdatabase's default collation Bootstrap collations Collname default Collprovider d Collencoding -1 Collversion _null_ Collisdeterministic t Collcollate _null_ Collctype _null_ Colliculocale … defaultCollations & EncodingsWikiCollations & Encodings · Collation provider identitiesDatabase-default collation selector. Collation provider identities Provider default Catalog code d Scope Source provider identity; installation/build availability is separate EUC_CNCollations & EncodingsWikiCollations & Encodings · Server encodingsExtended UNIX Code-CN Server encodings Encoding EUC_CN Encoding id 2 Language Simplified Chinese Server? Yes Icu? Yes Bytes/char 1-3 Bytes/char 1–3 EUC_JIS_2004Collations & EncodingsWikiCollations & Encodings · Server encodingsExtended UNIX Code-JP, JIS X 0213 Server encodings Encoding EUC_JIS_2004 Encoding id 5 Language Japanese Server? Yes Icu? No Bytes/char 1-3 Bytes/char 1–3 EUC_JPCollations & EncodingsWikiCollations & Encodings · Server encodingsExtended UNIX Code-JP Server encodings Encoding EUC_JP Encoding id 1 Language Japanese Server? Yes Icu? Yes Bytes/char 1-3 Bytes/char 1–3 EUC_KRCollations & EncodingsWikiCollations & Encodings · Server encodingsExtended UNIX Code-KR Server encodings Encoding EUC_KR Encoding id 3 Language Korean Server? Yes Icu? Yes Bytes/char 1-3 Bytes/char 1–3 EUC_TWCollations & EncodingsWikiCollations & Encodings · Server encodingsExtended UNIX Code-TW Server encodings Encoding EUC_TW Encoding id 4 Language Traditional Chinese, Taiwanese Server? Yes Icu? Yes Bytes/char 1-3 Bytes/char 1–4 GB18030Collations & EncodingsWikiCollations & Encodings · Client-only encodingsNational Standard, version 2022 Client-only encodings National Standard Encoding GB18030 Encoding id 39 Language Chinese Server? No Icu? No Bytes/char 1-4 Bytes/char 1–4 GBKCollations & EncodingsWikiCollations & Encodings · Client-only encodingsExtended National Standard Client-only encodings Encoding GBK Encoding id 37 Language Simplified Chinese Server? No Icu? No Bytes/char 1-2 Bytes/char 1–2 icuCollations & EncodingsWikiCollations & Encodings · Collation provider identitiescollation provider. Collation provider identities Provider icu Catalog code i Scope Source provider identity; installation/build availability is separate ISO_8859_5Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-5, ECMA 113 Server encodings Encoding ISO_8859_5 Encoding id 25 Language Latin/Cyrillic Server? Yes Icu? Yes Bytes/char 1 ISO_8859_6Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-6, ECMA 114 Server encodings Encoding ISO_8859_6 Encoding id 26 Language Latin/Arabic Server? Yes Icu? Yes Bytes/char 1 ISO_8859_7Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-7, ECMA 118 Server encodings Encoding ISO_8859_7 Encoding id 27 Language Latin/Greek Server? Yes Icu? Yes Bytes/char 1 ISO_8859_8Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-8, ECMA 121 Server encodings Encoding ISO_8859_8 Encoding id 28 Language Latin/Hebrew Server? Yes Icu? Yes Bytes/char 1 JOHABCollations & EncodingsWikiCollations & Encodings · Client-only encodingsClient-only encodings Encoding JOHAB Encoding id 40 Language Korean (Hangul) Server? No Icu? No Bytes/char 1-3 Bytes/char 1–3 KOI8RCollations & EncodingsWikiCollations & Encodings · Server encodingsKOI 8-R Server encodings Encoding KOI8R Encoding id 22 Language Cyrillic (Russian) Server? Yes Icu? Yes Bytes/char 1 KOI8UCollations & EncodingsWikiCollations & Encodings · Server encodingsKOI 8-U Server encodings Encoding KOI8U Encoding id 34 Language Cyrillic (Ukrainian) Server? Yes Icu? Yes Bytes/char 1 LATIN1Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-1, ECMA 94 Server encodings Encoding LATIN1 Encoding id 8 Language Western European Server? Yes Icu? Yes Bytes/char 1 LATIN10Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-16, ASRO SR 14111 Server encodings Encoding LATIN10 Encoding id 17 Language Romanian Server? Yes Icu? No Bytes/char 1 LATIN2Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-2, ECMA 94 Server encodings Encoding LATIN2 Encoding id 9 Language Central European Server? Yes Icu? Yes Bytes/char 1 LATIN3Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-3, ECMA 94 Server encodings Encoding LATIN3 Encoding id 10 Language South European Server? Yes Icu? Yes Bytes/char 1 LATIN4Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-4, ECMA 94 Server encodings Encoding LATIN4 Encoding id 11 Language North European Server? Yes Icu? Yes Bytes/char 1 LATIN5Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-9, ECMA 128 Server encodings Encoding LATIN5 Encoding id 12 Language Turkish Server? Yes Icu? Yes Bytes/char 1 LATIN6Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-10, ECMA 144 Server encodings Encoding LATIN6 Encoding id 13 Language Nordic Server? Yes Icu? Yes Bytes/char 1 LATIN7Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-13 Server encodings Encoding LATIN7 Encoding id 14 Language Baltic Server? Yes Icu? Yes Bytes/char 1 LATIN8Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-14 Server encodings Encoding LATIN8 Encoding id 15 Language Celtic Server? Yes Icu? Yes Bytes/char 1 LATIN9Collations & EncodingsWikiCollations & Encodings · Server encodingsISO 8859-15 Server encodings Encoding LATIN9 Encoding id 16 Language LATIN1 with Euro and accents Server? Yes Icu? Yes Bytes/char 1 libcCollations & EncodingsWikiCollations & Encodings · Collation provider identitiescollation provider. Collation provider identities Provider libc Catalog code c Scope Source provider identity; installation/build availability is separate MULE_INTERNALCollations & EncodingsWikiCollations & Encodings · Server encodingsMule internal code Server encodings Encoding MULE_INTERNAL Encoding id 7 Language Multilingual Emacs Server? Yes Icu? No Bytes/char 1-4 Bytes/char 1–4 pg_c_utf8Collations & EncodingsWikiCollations & Encodings · Bootstrap collationssorts by Unicode code point; Unicode and POSIX character semantics Bootstrap collations Collisdeterministic t Collcollate _null_ Collctype _null_ Colllocale C.UTF-8 Collicurules _null_ Coll… pg_unicode_fastCollations & EncodingsWikiCollations & Encodings · Bootstrap collationssorts by Unicode code point; Unicode character semantics Bootstrap collations Collisdeterministic t Collcollate _null_ Collctype _null_ Colllocale PG_UNICODE_FAST Collicurules _null_ Collve… POSIXCollations & EncodingsWikiCollations & Encodings · Bootstrap collationsstandard POSIX collation Bootstrap collations Collname POSIX Collprovider c Collencoding -1 Collcollate POSIX Collctype POSIX Collversion _null_ Collisdeterministic t Colliculocale _null_ C… SHIFT_JIS_2004Collations & EncodingsWikiCollations & Encodings · Client-only encodingsShift JIS, JIS X 0213 Client-only encodings Encoding SHIFT_JIS_2004 Encoding id 41 Language Japanese Server? No Icu? No Bytes/char 1-2 Bytes/char 1–2 SJISCollations & EncodingsWikiCollations & Encodings · Client-only encodingsShift JIS Client-only encodings Encoding SJIS Encoding id 35 Language Japanese Server? No Icu? No Bytes/char 1-2 Bytes/char 1–2 SQL_ASCIICollations & EncodingsWikiCollations & Encodings · Server encodingsunspecified (see text) Server encodings Encoding SQL_ASCII Encoding id 0 Language any Server? Yes Icu? No Bytes/char 1 ucs_basicCollations & EncodingsWikiCollations & Encodings · Bootstrap collationssorts by Unicode code point, C character semantics Bootstrap collations sorts by Unicode code point Collisdeterministic t Collcollate C Collctype C Colliculocale _null_ Collicurules _null_ … UHCCollations & EncodingsWikiCollations & Encodings · Client-only encodingsUnified Hangul Code Client-only encodings Encoding UHC Encoding id 38 Language Korean Server? No Icu? No Bytes/char 1-2 Bytes/char 1–2
More results

Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.

Searching every version by default. Manual pages are indexed for PostgreSQL 10–20; the reference library and extension catalogue are not version-bound.

all: every version pg17: one version ex: extensions only ↑↓ select ↵ open