select open change scope Open full search

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

Extensions / Data types

citext

data type for case-insensitive character strings

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packagecitext
Version1.6
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

launchql-ext-types🛠. basic pg utils
pgpm-fakerPostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.
pgpm-typesPostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes.
qgresSimple queue system
typesReusable domains for attachments, email addresses, hostnames, images, uploads, and URLs.

See also

unaccenttext search dictionary that removes accents
icu_extAccess ICU functions
pg_trgmtext similarity measurement and index searching based on trigrams
pg_xenophileMore than the bare necessities for PostgreSQL i18n and l10n.
gb18030_2022Support GB18030-2022 and UTF-8 conversion
pg_cjk_parserCJK bigram parser derived from PostgreSQL full-text search
dict_xsyntext search dictionary template for extended synonym processing
pgroongaUse Groonga as index, fast full text search platform for all languages!
pg_tokenizerTokenizers for full-text search
pgpcrePerl Compatible Regular Expression functions