FORCE NOT NULL|
FORCE NULL] [,
FORCE NOT NULL|
FORCE NULL], ...])
Create a table named
tablename, and having the OID
tableoid, with the columns given in parentheses.
The following column types are supported directly by
char (1 byte),
_aclitem (array). Although it is possible to create tables containing columns of other types, this cannot be done until after
pg_type has been created and filled with appropriate entries. (That effectively means that only these column types can be used in bootstrap catalogs, but non-bootstrap catalogs can contain any built-in type.)
bootstrap is specified, the table will only be created on disk; nothing is entered into
pg_attribute, etc., for it. Thus the table will not be accessible by ordinary SQL operations until such entries are made the hard way (with
insert commands). This option is used for creating
pg_class etc. themselves.
The table is created as shared if
shared_relation is specified. The table's row type OID (
pg_type OID) can optionally be specified via the
rowtype_oid clause; if not specified, an OID is automatically generated for it. (The
rowtype_oid clause is useless if
bootstrap is specified, but it can be provided anyway for documentation.)
Open the table named
tablename for insertion of data. Any currently open table is closed.
Close the open table. The name of the table must be given as a cross-check.
Insert a new row into the open table using
value2, etc., for its column values.
NULL values can be specified using the special key word
_null_. Values that do not look like identifiers or digit strings must be single-quoted. (To include a single quote in a value, write it twice. Escape-string-style backslash escapes are allowed in the string, too.)
Create an index named
indexname, having OID
indexoid, on the table named
tablename, using the
amname access method. The fields to index are called
name2 etc., and the operator classes to use are
opclass2 etc., respectively. The index file is created and appropriate catalog entries are made for it, but the index contents are not initialized by this command.
Create a TOAST table for the table named
tablename. The TOAST table is assigned OID
toasttableoid and its index is assigned OID
toastindexoid. As with
declare index, filling of the index is postponed.
Fill in the indices that have previously been declared.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.