Skip to content

Instantly share code, notes, and snippets.

@learntheropes

learntheropes/create_postgres_email_extension.sh

Created January 31, 2024 15:28
Show Gist options
  • Save learntheropes/6e7af8dda77795a651d237f995f74af1 to your computer and use it in GitHub Desktop.
Save learntheropes/6e7af8dda77795a651d237f995f74af1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_postgres_email_extension.sh
CREATE EXTENSION citext;
CREATE DOMAIN email AS citext
CHECK ( value ~ '^[a-zA-Z0-9.!#$%&''*+/=?^_`{|}~-]+@[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?(?:\.[a-zA-Z0-9](?:[a-zA-Z0-9-]{0,61}[a-zA-Z0-9])?)*$' );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment