Shareware software
FUNCTION Node for PostgreSQL
List of functions in the selected database schema PostgreSQL . The list can be filtered by entering part of the table name in the " Like name object " field
Menu
Drop function - generate a command code for deleting a function
Set search_path - generate a command to specify the search path function
Set schema - generate a command to move a function to another schema
Rename - generate a command to rename a function
Owner to - generate a command to change the owner of the function
Select code - generate a command to call a function (select command)
Perform code - generate a command to call a function (perform command)
Get DDL - generate function creation code
Feature List
SELECT p.oid, 'core' AS schema_name
,p.proname AS function_name
,pg_get_function_arguments(p.oid) AS args
,(SELECT rolname
FROM pg_roles
WHERE oid = p.proowner) "owner"
,pg_get_function_result(p.oid) AS ret
FROM pg_catalog.pg_proc p
WHERE p.pronamespace = (select oid
from pg_catalog.pg_namespace
where nspname = $$SCHEMANAME)
and prokind in ('f','a','w')
order by p.proname
Get DDL
select pg_get_functiondef($$OID)