...T ON OPERATOR - (NONE, integer) IS 'Unary minus'; COMMENT ON OPERATOR CLASS int4ops USING btree IS '4 byte integer operators for btrees'; COMMENT ON OPERATOR FAMILY integer_ops …...must be specified. sort_family_name The name (optionally schema-qualified) of an existing btree operator family that describes the sort ordering associated with an ordering oper…...XAMPLES Remove the B-tree operator family float_ops: DROP OPERATOR FAMILY float_ops USING btree; This command will not succeed if there are any existing indexes that use operato…...XAMPLES Remove the B-tree operator class widget_ops: DROP OPERATOR CLASS widget_ops USING btree; This command will not succeed if there are any existing indexes that use the ope…..." Column | Type | Modifiers --------+---------+----------- col | integer | Indexes: "idx" btree (col) "idx_ccnew" btree (col) INVALID If the index marked INVALID is suffixed _cc…...-type comparisons. sort_family_name The name (optionally schema-qualified) of an existing btree operator family that describes the sort ordering associated with an ordering oper…...) of the table to be indexed. method The name of the index method to be used. Choices are btree, hash, gist, spgist, gin, brin, or user-installed access methods like bloom. The …...key must consist of a single column or expression. Range and list partitioning require a btree operator class, while hash partitioning requires a hash operator class. If no oper…