Skip to main content
Version: 2.x

citext

The citext module provides a case-insensitive character string data type, citext. Essentially, it internally calls the lower() function when comparing values. Otherwise, it behaves almost exactly like the text data type.

The Apache Cloudberry citext module is equivalent to the PostgreSQL citext module. There are no MPP-specific considerations for the module.

Install and register the module​

citext is built and installed by a default Apache Cloudberry build. Register the extension in each database in which you want to use it:

CREATE EXTENSION citext;

Module documentation​

See citext in the PostgreSQL documentation for details about the data type, operators, and functions that this module defines.