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