case insensitive in regex in postgresql query November 30, 2023 by Tarik You must use ~* instead of ~.