The citext type automatically does case-insensitive comparisons: https://www.postgresql.org/docs/current/static/citext.html