select open change scope Open full search

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

SYSTEM CATALOGS / SYSTEM CATALOGS

The catalog pg_amproc stores information about support functions associated with access method operator families.

Kind
System catalogs
Columns in this snapshot
6
Definition source
English manual

Columns 6

ColumnTypeDescription / reference
oidoidRow identifier
amprocfamilyoidThe operator family this entry is for
pg_opfamily.oid
amproclefttypeoidLeft-hand input data type of associated operator
pg_type.oid
amprocrighttypeoidRight-hand input data type of associated operator
pg_type.oid
amprocnumint2Support function number
amprocregprocOID of the function
pg_proc.oid
Column history across versions
Version history 3
  1. PG 11 → 12changed
  2. PG 10 → 11changed
  3. PG 9.2 → 9.3changed

Definition snapshot: english-manuals:8e37fbb6d7736bdee8684465e2b… · English manual source