URL Functions

    The extracted components do not contain URI syntax separators such as or ?.

    url_extract_fragment(url) → varchar

    Returns the fragment identifier from url.

    url_extract_host(url) → varchar

    Returns the host from url.

    url_extract_parameter(url, name) → varchar

    Returns the value of the first query string parameter named name from url. Parameter extraction is handled in the typical manner as specified by RFC 1866#section-8.2.1.

    Returns the path from .

    url_extract_port(url) → bigint

    Returns the port number from url.

    url_extract_protocol(url) → varchar

    Returns the protocol from url.

    url_extract_query(url) → varchar

    Returns the query string from url.

    Encoding Functions

    Escapes value by encoding it so that it can be safely included in URL query parameter names and values:

    • Alphanumeric characters are not encoded.

    • The ASCII space character is encoded as +.

    url_decode(value) → varchar

    Unescapes the URL encoded . This function is the inverse of url_encode().