digoal
2020-03-24
PostgreSQL , email
https://github.com/petere/pgemailaddr
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>).
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议,奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等,奖品丰富,快来许愿。开不开森.