Operator Class¶

An operator class (CREATE OPERATOR CLASS): how an index method uses the operators and support functions of a data type.

Properties¶

Property	Type	Required	Description
`name`	`string`	yes	The name of the operator class.
`schema`	`string`	yes	The schema the operator class is created in.
`owner`	`string`	—	The role that owns the operator class.
`method`	`string`	yes	The index access method the class is for (USING).
`data_type`	`string`	yes	The column data type the class is for (FOR TYPE).
`default`	`boolean`	—	The class is the default for its data type and index method.
`family`	`string`	—	The operator family the class belongs to, schema-qualified. Without it, PostgreSQL makes a family with the name of the class.
`storage`	`string`	—	The data type stored in the index (STORAGE), when it is not the column data type.
`operators`	array of operator_class_operator	—	The operators of the class.
`functions`	array of operator_class_function	—	The support functions of the class.
`comment`	`string`	—	An optional comment about the operator class.

No other properties are accepted.