Contents
CREATE TYPE
An SQL command for creating a custom data type
CREATE TYPE
is a DDL command for creating a custom data type.
CREATE TYPE
has always been present in PostgreSQL.
Change history
Work-in-progress
- PostgreSQL 14
SUBSCRIPT
function handler option added (commit c7aba7c1)
- PostgreSQL 9.1
- option
COLLATABLE
added (commit 414c5a2e)
- option
- PostgreSQL 8.4
- PostgreSQL 8.3
- PostgreSQL 8.2
- stand-alone
CREATE TYPE
syntax added for creating shell types (commit 8e68d783)name
- stand-alone
- PostgreSQL 8.0
- option
ANALYZE
added (commit 69946411)
- option
- PostgreSQL 7.4
- options
SEND
andRECEIVE
re-added (commit 45d04099)
- options
- PostgreSQL 7.3
References
- PostgreSQL documentation: CREATE TYPE