Mega Code Archive

Displays all functions in the connected database, with comments

postgres=# postgres=# --Displays all functions in the connected database, with comments. postgres=# \df+ List of functions Schema | Name | Result data type | Argument data types | Owner | Language | Source code | Description ------------+------------------------------------+-----------------------------+--------------------------------------------------------------------------------------------------------------------+----------+----------+--------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------ -------------------------------------------------------------------------------------- pg_catalog | RI_FKey_cascade_del | "trigger" | | postgres | internal | RI_FKey_cascade_del | referential integrity ON DELETE CASCADE pg_catalog | RI_FKey_cascade_upd | "trigger" | | postgres | internal | RI_FKey_cascade_upd | referential integrity ON UPDATE CASCADE pg_catalog | RI_FKey_check_ins | "trigger" | | postgres | internal | RI_FKey_check_ins | referential integrity FOREIGN KEY ... REFERENCES pg_catalog | RI_FKey_check_upd | "trigger" | | postgres | internal | RI_FKey_check_upd | referential integrity FOREIGN KEY ... REFERENCES pg_catalog | RI_FKey_noaction_del | "trigger" | | postgres | internal | RI_FKey_noaction_del | referential integrity ON DELETE NO ACTION pg_catalog | RI_FKey_noaction_upd | "trigger" | | postgres | internal | RI_FKey_noaction_upd | referential integrity ON UPDATE NO ACTION pg_catalog | RI_FKey_restrict_del | "trigger" | | postgres | internal | RI_FKey_restrict_del | referential integrity ON DELETE RESTRICT pg_catalog | RI_FKey_restrict_upd | "trigger" | | postgres | internal | RI_FKey_restrict_upd | referential integrity ON UPDATE RESTRICT pg_catalog | RI_FKey_setdefault_del | "trigger" | | postgres | internal | RI_FKey_setdefault_del | referential integrity ON DELETE SET DEFAULT pg_catalog | RI_FKey_setdefault_upd | "trigger" | | postgres | internal | RI_FKey_setdefault_upd | referential integrity ON UPDATE SET DEFAULT pg_catalog | RI_FKey_setnull_del | "trigger" | | postgres | internal | RI_FKey_setnull_del | referential integrity ON DELETE SET NULL pg_catalog | RI_FKey_setnull_upd | "trigger" | | postgres | internal | RI_FKey_setnull_upd | referential -- More --