PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System catalogs

pg_opfamily

Read the PG 18 manual

The catalog pg_opfamily defines operator families.

Reading PG 18current·documented in 20 of 24 versions, 8.3 to 20

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Kind: System catalogs
Columns in this snapshot: 5
Definition source: English manual
Metadata snapshot: 18.6

Columns 5

As listed in the PostgreSQL 18 manual.

Column	Type	Description / reference
`oid`	`oid`NOT NULL	Row identifier
`opfmethod`	`oid`NOT NULL	Index access method operator family is for pg_am.oid
`opfname`	`name`NOT NULL	Name of this operator family
`opfnamespace`	`oid`NOT NULL	Namespace of this operator family pg_namespace.oid
`opfowner`	`oid`NOT NULL	Owner of the operator family pg_authid.oid

Column history across versions

oid

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

opfmethod

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

opfname

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

opfnamespace

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

opfowner

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Version history 8

16 → 17 reworded
13 → 14 reworded
11 → 12 changed
10 → 11 reworded
9.6 → 10 reworded
9.5 → 9.6 reworded
8.4 → 9.0 reworded
8.2 → 8.3 added

Definition snapshot: english-manuals:1ca5d885210bb7345f165b9a279… · English manual source