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 WarehousePG citext module is equivalent to the PostgreSQL citext module. There are no WarehousePG or MPP-specific considerations for the module.

Installing and Registering the Module

The citext module is installed when you install WarehousePG. Before you can use any of the data types, operators, or functions defined in the module, you must register the citext extension in each database in which you want to use the objects. Refer to Installing Extensions for more information.

Module Documentation

See citext in the PostgreSQL documentation for detailed information about the data types, operators, and functions defined in this module.