-
Notifications
You must be signed in to change notification settings - Fork 197
Add Comment/Description stored procedures and functions #775
Copy link
Copy link
Open
Labels
Description
As per #307 (comment).
the functions table should show the comment of the function like for tables, columns, etc. Right now the comments are not shown anywhere which makes the table not that useful for documentation.
For postgresql the following query should be updated.
SELECT n.nspname AS schema_name,
p.proname AS specific_name,
TEXT 'FUNCTION',
t.typname AS return_type,
pg_get_function_arguments(p.oid) AS arguments,
d.description AS description
from pg_proc p
LEFT JOIN pg_namespace n ON p.pronamespace = n.oid
LEFT JOIN pg_type t ON n.oid = p.prorettype
LEFT JOIN pg_description d ON d.objoid = n.oid
WHERE n.nspname NOT IN ('pg_catalog', 'information_schema')
Reactions are currently unavailable