<refsynopsisdiv>

<synopsis>

CREATE TYPE <replaceable class="parameter">name</replaceable> AS

( [ <replaceable class="PARAMETER">attribute_name</replaceable> <replaceable class="PARAMETER">data_type</replaceable> [, ... ] ] )

( [ <replaceable class="PARAMETER">attribute_name</replaceable> <replaceable class="PARAMETER">data_type</replaceable> [ COLLATE <replaceable>collation</replaceable> ] [, ... ] ] )

CREATE TYPE <replaceable class="parameter">name</replaceable> AS ENUM

( [ '<replaceable class="parameter">label</replaceable>' [, ... ] ] )

The first form of <command>CREATE TYPE</command>

creates a composite type.

The composite type is specified by a list of attribute names and data types.

This is essentially the same as the row type

An attribute's collation can be specified too, if its data type is

collatable. A composite type is essentially the same as the row type

of a table, but using <command>CREATE TYPE</command> avoids the need to

create an actual table when all that is wanted is to define a type.

A stand-alone composite type is usefulas the argument or return type of a

function.

A stand-alone composite type is useful, for example,as the argument or

return type of afunction.

</para>

</refsect2>