URL Datatype

The related URL data type is a subdomain over character strings and represent valid Uniform Resource Locators.

Usage example:

CREATE TABLE URL_example (c1 URL, c2 URL(512) NOT NULL);

You can use cast() or convert() functions to convert a valid url string to a url type.

select cast('https://www.monetdb.org/documentation/user-guide/' as url);

select convert('https://www.monetdb.org/documentation/user-guide/', url);

You can also use the url prefix:

select url 'https://www.monetdb.org/documentation/user-guide/';

A collection of URL functions are available to create new URLs or extract portions of an URL.