Skip to content
email address type for PostgreSQL
C PLSQL Makefile
Branch: master
Clone or download
Latest commit 77266f2 Nov 20, 2015
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
test First commit Nov 20, 2015
.gitignore First commit Nov 20, 2015
Makefile First commit Nov 20, 2015
README.md First commit Nov 20, 2015
emailaddr--0.sql First commit Nov 20, 2015
emailaddr.c First commit Nov 20, 2015
emailaddr.control First commit Nov 20, 2015

README.md

emailaddr type for PostgreSQL

https://twitter.com/pvh/status/667106073199775744

This is an extension for PostgreSQL that provides a type emailaddr for storing email addresses.

Installation

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;

Using

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', 'peter@eisentraut.org');

The accepted addresses correspond approximately to the addr-spec production in RFC 5322 (so it's of the type foo@bar.com, but not "Some Name" <foo@bar.com>).

Request for feedback

Let me now what other functionality you wish to see in an email address type.

You can’t perform that action at this time.