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 --
Related examples in the same category