create table\(em create a new class

.nf

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

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

[\fB,\fP attname type [\fBdefault\fP value] [\fBnotnull\fP] ]\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 may have a default value, specified by the

.IR default

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

\fBNote\fR: DEFAULT in version 6.2 works like constraint - there is no

way to insert NULL into an attribute having DEFAULT value.

.PP

Each array attribute stores arrays that must have the same number of

dimensions but may have different sizes and array index bounds. An