DMS¶
List all domains in use¶
SQL¶
SELECT DISTINCT substring(url from '^https?://([^/]+)') AS url
FROM (
SELECT unnest(regexp_split_to_array(alias, E'\n')) AS url
FROM nice_domain
WHERE alias <> ''
UNION SELECT url
FROM nice_domain
WHERE url <> ''
) AS sub
ORDER BY 1;
Sample output¶
extranet.tocco.ch
manual.tocco.ch
tocco.ch
www.tocco.ch