Browse categories
Random entry
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (rc2)
- PostgreSQL 14 (latest)
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

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)
PostgreSQL 8.4
- option LIKE added (commit 3f936aac)
- options CATEGORY and PREFERRED added (commit bac3e836)
PostgreSQL 8.3
- CREATE TYPE ... AS ENUM ... syntax added (commit 57690c68)
- options TYPMOD_IN and TYPMOD_OUT added (commit 5725b9d9)
PostgreSQL 8.2
- stand-alone CREATE TYPE name syntax added for creating shell types (commit 8e68d783)
PostgreSQL 8.0
- option ANALYZE added (commit 69946411)
PostgreSQL 7.4
- options SEND and RECEIVE re-added (commit 45d04099)
PostgreSQL 7.3
- CREATE TYPE ... AS ( column_name data_type [, ... ] ) syntax added (commit b1a5f872)
- options EXTERNALLENGTH, VARIABLE, SEND and RECEIVE removed (commit 739adf32)

References

PostgreSQL documentation: CREATE TYPE

Categories

See also

ALTER TYPE, DROP TYPE, pg_type