top of page
Волнистый абстрактный фон
CerebroSQL

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

PostgreSQL function list
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)

bottom of page