https://twitter.com/pvh/status/667106073199775744
This is an extension for PostgreSQL that provides a type emailaddr
for storing email addresses.
To build and install this module:
make
make install
or selecting a specific PostgreSQL installation:
make PG_CONFIG=/some/where/bin/pg_config
make PG_CONFIG=/some/where/bin/pg_config install
And finally inside the database:
CREATE EXTENSION emailaddr;
This module provides a data type emailaddr that you can use like a
normal type. For example:
CREATE TABLE accounts (
id int PRIMARY KEY,
name text,
email emailaddr
);
INSERT INTO accounts VALUES (1, 'Peter Eisentraut', '[email protected]');The accepted addresses correspond approximately to the addr-spec
production in RFC 5322
(so it's of the type [email protected], but not "Some Name" <[email protected]>).
Let me now what other functionality you wish to see in an email address type.