[ncd]

Postgres also has the citext column type to make this a snap.

https://www.postgresql.org/docs/9.6/static/citext.html