This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
PostgreSQL CITEXT type
Supported by ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The CITEXT type stands for "case insensitive text," which simplifies handling scenarios where case insensitive comparisons are made frequently while still storing and projecting the original case. There is no special data type to represent a CITEXT column in Java, it's just a java.lang.String.
Support for this data type is included in the jooq-postgres-extensions module.
Feedback
Do you have any feedback about this page? We'd love to hear it!