Hostname
Type Registry
Hostname
technology.internet.hostname Fully qualified domain name or simple hostname. Does not include protocol or path. Allows alphanumeric characters, hyphens, and dots. Subdomains supported.
Domain technology›internet
Casts to VARCHAR
Scope Universal
Try it
CLI
$ finetype infer -i "example.com"
→ technology.internet.hostname DuckDB
Detect
SELECT finetype('example.com');
-- → 'technology.internet.hostname' Cast expression
CAST({col} AS VARCHAR) Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'technology.internet.hostname'; JSON Schema
finetype schema technology.internet.hostname {
"$id": "https://noon.sh/schemas/technology.internet.hostname",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Fully qualified domain name or simple hostname. Does not include protocol or path. Allows alphanumeric characters, hyphens, and dots. Subdomains supported.",
"examples": [
"example.com",
"www.google.com",
"subdomain.example.org",
"localhost"
],
"pattern": "^(?:(?:[a-z0-9](?:[a-z0-9-]{0,61}[a-z0-9])?\\.)*[a-z0-9](?:[a-z0-9-]{0,61}[a-z0-9])?)$",
"title": "Hostname",
"type": "string"
} Examples
example.comwww.google.comsubdomain.example.orglocalhost Also known as
domain_name