CREATE DOMAIN
An SQL command for defining a domain
CREATE DOMAIN is a DDL command for defining a domain.
CREATE DOMAIN was added in PostgreSQL 7.3.
Change history
- PostgreSQL 9.1
COLLATEclause added (commit 414c5a2e)
- PostgreSQL 7.4
CHECKclause added (commit 6b603e67)
- PostgreSQL 7.3
- added (commit 01c76f74)
Examples
Basie domain creation example:
postgres=# CREATE DOMAIN git_sha1 AS CHAR(40) NOT NULL CHECK (VALUE ~ '^[0-9a-fA-F]+$'); CREATE DOMAIN
This, as the name implies, defines a domain suitable for storing a GIT sha1 tag.
References
- PostgreSQL documentation: CREATE DOMAIN
Useful links
- CREATE DOMAIN: Data type abstraction - October 2013 blog article by Hans-Jürgen Schönig / CyberTec