↑↓ 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.

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

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

Columns 6

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
amprocfamilyoidNOT NULLThe operator family this entry is for
pg_opfamily.oid
amproclefttypeoidNOT NULLLeft-hand input data type of associated operator
pg_type.oid
amprocrighttypeoidNOT NULLRight-hand input data type of associated operator
pg_type.oid
amprocnumint2NOT NULLSupport function number
amprocregprocNOT NULLOID of the function
pg_proc.oid
Column history across versions
Version history 4
  1. 11 → 12 changed
  2. 10 → 11 reworded
  3. 8.2 → 8.3 changed
  4. 7.4 → 8.0 changed

Definition snapshot: english-manuals:88335db888403b1cf2be2bc4581… · English manual source