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
COLLATE
clause added (commit 414c5a2e)
- PostgreSQL 7.4
CHECK
clause added (commit 6b603e67)
- PostgreSQL 7.3
- added (commit 01c76f74)
Examples
Basie execution example for CREATE DOMAIN
:
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