pg_html5_email_address
PostgreSQL email validation that is consistent with the HTML5 spec
pg_html5_email_address : PostgreSQL email validation that is consistent with the HTML5 spec
Overview
| ID | Extension | Package | Version | Category | License | Language |
|---|---|---|---|---|---|---|
| 4180 | pg_html5_email_address | pg_html5_email_address | 1.2.3 |
UTIL | PostgreSQL | SQL |
| Attribute | Has Binary | Has Library | Need Load | Has DDL | Relocatable | Trusted |
|---|---|---|---|---|---|---|
| ----d-r | No | No | No | Yes | yes | no |
| Relationships | |
|---|---|
| See Also | emailaddr uri pg_utl_smtp pg_smtp_client omni_email url_encode ip4r prefix |
Packages
| Type | Repo | Version | PG Major Compatibility | Package Pattern | Dependencies |
|---|---|---|---|---|---|
| EXT | PIGSTY | 1.2.3 |
18 17 16 15 14 | pg_html5_email_address |
- |
| RPM | PIGSTY | 1.2.3 |
18 17 16 15 14 | pg_html5_email_address_$v |
- |
| DEB | PIGSTY | 1.2.3 |
18 17 16 15 14 | postgresql-$v-pg-html5-email-address |
- |
| Linux / PG | PG18 | PG17 | PG16 | PG15 | PG14 |
|---|---|---|---|---|---|
| el8.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| el8.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| el9.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| el9.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| el10.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| el10.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| d12.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| d12.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| d13.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| d13.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| u22.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| u22.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| u24.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| u24.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| u26.x86_64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
| u26.aarch64 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 | PIGSTY 1.2.3 |
Source
github.com/bigsmoke/pg_html5_email_address
pg_html5_email_address-1.2.3.tar.gz
Install
Make sure PGDG and PIGSTY repo available:
Install this extension with pig:
Create this extension with:
Usage
pg_html5_email_address: HTML5 email address validation for PostgreSQL
Provides email address validation consistent with the HTML5 <input type="email"> specification.
Domain Type: html5_email
A domain type that enforces HTML5 email validation rules with case-insensitive comparison:
Function: html5_email_regexp()
Returns a regex matching valid HTML5 email addresses:
With optional capturing groups for local and domain parts:
Validation Rules
- Spaces are not allowed
- Non-ASCII characters are not allowed (neither in local nor domain part)
- There must be something after the
@ - Special characters like
!#$%&'*+/=?^_{|}~-` are allowed in the local part