Domain

Domains are basically semantic aliases for build in types with some extra constraints called Checks.

The Config Load Directory is domains.d and must contain files with the following strucutre.

name SQL Identifier

Name

description String

Description

type SQL Type

Type

default String

Default

checks List [Check]

Checks

Examples

name: email_address
description: Valid email address
type: varying(254)

checks:
 -
  name: email_regex
  description: |
   Ensures that the address contains an ``@`` and something before the ``@``
  check: |
   POSITION('@' IN VALUE) > 1

External Resources

• PostgreSQL’s CREATE DOMAIN statement