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.