citext

data type for case-insensitive character strings

Overview

ID	Extension	Package	Version	Category	License	Language
3980	citext	citext	`1.6`	TYPE	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-dt-	No	Yes	No	Yes	no	yes

Relationships
See Also	prefix semver ltree unaccent unit pgpdf pglite_fusion md5hash

PG18	PG17	PG16	PG15	PG14	PG13
1.6	1.6	1.6	1.6	1.6	1.6

This is a built-in contrib extension ship with the PostgreSQL kernel

Create this extension with:

CREATE EXTENSION citext;

Last updated on 2025-10-28