Quoting from the referenced link below, posix operators are:
Operator | Description | Example |
---|---|---|
~ | Matches regular expression, case sensitive | 'thomas' ~ '.thomas.' |
~* | Matches regular expression, case insensitive | 'thomas' ~* '.Thomas.' |
!~ | Does not match regular expression, case sensitive | 'thomas' !~ '.Thomas.' |
!~* | Does not match regular expression, case insensitive | 'thomas' !~* '.vadim.' |
Reference: https://www.postgresql.org/docs/11/functions-matching.html#FUNCTIONS-POSIX-REGEXP
- links to