create table\(em create a new class

.nf

\fBcreatetable\fR classname\fB(\fPattname type [\fBdefault\fP value]

[\fB,\fP attname type [\fBdefault\fP value] ]\fB)\fP

\fBcreatetable\fR classname\fB(\fPattname type [not null] [\fBdefault\fP value]

[\fB,\fP attname type [\fBnotnull\fP] [\fBdefault\fP value] ]\fB)\fP

[\fBinherits\fR\fB(\fR classname [\fB,\fR classname]\fB)\fR]

[\fBconstraint\fR cname\fBcheck\fR\fB(\fR test\fB)\fR [,\fBcheck\fR\fB(\fR test\fB)\fR ] ]

[\fBarchive\fR\fB=\fR archive_mode]

Each attribute is created with the type specified by

.IR type"."

Each type may be a simple type, a complex type (set) or an array type.

Each attribute may have a default value, specified by the

Each attribute may be specified to be non-null and

each may have a default value, specified by the

.IR default

clause which is the keyword "default" followed by a constant or expression.

.PP

This section describes the data types, functions and operators

`year', `month', `day', `hour', `minute', and `second',

as well as the more specialized quantities

`decade', `century', `millenium', `millisecond', and `microsecond'.

date_part()alsoallows

to return day of weekand`epoch' to return secondssince 1970.

date_part() allows `dow'

and'epoch' to returntotal elapsedsecondsfor timespan.

.nf

Functions: