What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

To match a regular expression that is case insensitive, you can use the POSIX regular expression (~*) from the pattern matching operators.

Example