This is an extension for PostgreSQL that provides a
uridata type. Advantages over using plain
textfor storing URIs include:
- URI syntax checking
- functions for extracting URI components
- human-friendly sorting
Note that this might not be the right data type to use if you want to store user-provided URI data, such as HTTP referrers, since they might contain arbitrary junk.