Топ-100
 
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.jpg
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)