What is the operator that is used for case-insensitive regular express

1.	What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?
Answer» To MATCH a regular EXPRESSION that is CASE insensitive, you can use the POSIX regular expression (~) from the pattern MATCHING operators. Example 'umesh' ~ '.Umesh.'

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

Answer»

To MATCH a regular EXPRESSION that is CASE insensitive, you can use the POSIX regular expression (~*) from the pattern MATCHING operators.

Example

'umesh' ~* '.*Umesh.*'