URI data type for PostgreSQL
This is an extension for PostgreSQL that provides a
uridata type. Advantages over using plaintextfor storing URIs include:
- URI syntax checking
- functions for extracting URI components
- human-friendly sorting
The actual URI parsing is provided by the uriparser library, which supports URI syntax as per RFC 3986.
source:
$link[host]
Read Original Source