Storing Emails With citext
Email addresses should be treated as case-insensitive because they are. If a
user is trying to sign in with their email address, we shouldn't care if
User@example.com. Both of those email
addresses should be treated as equal and ultimately lead us to the same
extension in PostgreSQL, we can create a column that acts as a case-insensitive text type.
Any comparisons on a column of that type will internally have the
function executed on the arguments.
The following example shows this in action:
create extension if not exists citext; create table citext_emails ( id serial primary key, email citext not null unique ); insert into citext_emails (email) values ('LizLemon@nbc.com'); select * from citext_emails where email = 'firstname.lastname@example.org'; -- id | email -- ----+------------------ -- 1 | LizLemon@nbc.com
for a full example.