The pg_amproc
table stores information about support procedures associated with index access method operator classes. There is one row for each support procedure belonging to an operator class.
column | type | references | description |
---|---|---|---|
oid | oid | Row identifier (hidden attribute; must be explicitly selected) | |
amprocfamily | oid | pg_opfamily.oid | The operator family this entry is for |
amproclefttype | oid | pg_type.oid | Left-hand input data type of associated operator |
amprocrighttype | oid | pg_type.oid | Right-hand input data type of associated operator |
amprocnum | int2 | Support procedure number | |
amproc | regproc | pg_proc.oid | OID of the procedure |
Parent topic: System Catalogs Definitions