Domains

    You can use domains anywhere corresponding base type can be used:

    • Create a column of domain type
    • Read/write values from/to domain column
    • Call functions with values of domain column
    • etc.
    • Explicit column type name in or DESCRIBE TABLE
    • Input from human-friendly format with
    • Loading data from external source in human-friendly format:

    Limitations

    • Can’t convert index column of base type to domain type via ALTER TABLE.
    • Can’t implicitly convert string values into domain values when inserting data from another column or table.
    • Domain adds no constrains on stored values.