Displays all functions in the connected database, with comments : Postgre SQL Command « Postgre SQL « PostgreSQL






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

1.Command can be used to view all sequences in the currently connected database
2.Displays all databases available, with comments
3.Listing psql slash commands
4.The variable list
5.Displays all database objects, with comments
6.Displays all database objects in the connected database, with comments
7.Displays all tables in the connected database, with comments
8.Displays all indices in the connected database, with comments
9.Displays all sequences in the connected database, with comments
10.Displays all views in the connected database, with comments
11.Displays all operators in the connected database, with comments
12.Displays all data types in the connected database, with comments
13.To get out of psql
14.timestamp with time zone postmaster start time