URI functions
XTDB has support for first-class URIs, with the following functions:
Constructors
URI 'https://…'
-
URI constructor
CAST('…' AS URI)
,'…'::URI
-
cast a string to a URI
Extraction functions
The following functions extract components from a URI:
URI_SCHEME(URI 'https://xtdb.com')
-
returns the scheme of the URI (e.g.
https
) URI_USER_INFO(URI 'https://user:pass@xtdb.com')
-
returns the user info of the URI (e.g.
user:pass
) URI_HOST(URI 'https://xtdb.com')
-
returns the host of the URI (e.g.
xtdb.com
) URI_PORT(URI 'https://xtdb.com:8080')
-
returns the port of the URI (e.g.
8080
) URI_PATH(URI 'https://xtdb.com:8080/path/to/resource')
-
returns the path of the URI (e.g.
/path/to/resource
), or an empty string if the path is not specified in the URI. URI_QUERY(URI 'https://xtdb.com:8080/path/to/resource?query=string')
-
returns the query of the URI (e.g.
query=string
) URI_FRAGMENT(URI 'https://xtdb.com:8080/path/to/resource#fragment')
-
returns the fragment of the URI (e.g.
fragment
)
All functions (unless otherwise specified) return NULL
if the component is not specified in the URI.