The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/citext.html Description:
The citext plugin does not work in combination with jdbc. Thus it does not work with Java applications. It does work in pgadmin because that is python. I am using the right schema, and setting the jdbc stringtype to unspecified makes no difference. Because Java is the most used programming language, a big warning on the postgresql citext documentation (https://www.postgresql.org/docs/10/citext.html) is needed until this is fixed. Case insensitive text is standard on many databases, thus this may be a big obstacle when you want to migrate.
