Extensions / Functions and aggregates
Normalize email addresses in PostgreSQL
pgext.cloud · Source code · Documentation · License text · Control file · PGXN
| Package | pg_normalize_email |
|---|---|
| Version | 1.0.9 |
| PostgreSQL versions | 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | SQL only |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 3 |
| Latest commit | 2025-05-19 |
| Latest release | 2025-05-19 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| Email address data type with validation, equality operators, and user/domain helper functions. | |
| pgsmtp | Send SMTP email and file attachments from PostgreSQL using untrusted PL/Python functions. |
| pg_sendmail | Sends email from SQL by invoking a sendmail-compatible executable at a fixed server path. |
| email_guard | Supabase Auth signup guard that blocks disposable email domains and normalizes Gmail addresses. |
| pg_html5_email_address | PostgreSQL email validation that is consistent with the HTML5 spec |
| types | Reusable domains for attachments, email addresses, hostnames, images, uploads, and URLs. |
| emailaddr | Email address type for PostgreSQL |
| pg_smtp_client | PostgreSQL extension to send email using SMTP |