Skip to content

Latest commit

 

History

History
56 lines (38 loc) · 2.21 KB

functions.md

File metadata and controls

56 lines (38 loc) · 2.21 KB

Function Operations

pgm.createFunction( function_name, function_params, function_options, definition )

Create a new function - postgres docs

Arguments:

  • function_name [Name] - name of the new function

  • function_params [array] - parameters of the new function

    Either array of strings or objects. If array of strings, it is interpreted as is, if array of objects:

    • mode [string] - IN, OUT, INOUT, or VARIADIC
    • name [string] - name of argument
    • type [string] - datatype of argument
    • default [string] - default value of argument
  • function_options [object] - options:

    • returns [string] - returns clause
    • language [string] - language name of function definition
    • replace [boolean] - create or replace function
    • window [boolean] - window function
    • behavior [string] - IMMUTABLE, STABLE, or VOLATILE
    • onNull [boolean] - RETURNS NULL ON NULL INPUT
    • parallel [string] - UNSAFE, RESTRICTED, or SAFE
  • definition [string] - definition of function

Reverse Operation: dropFunction


pgm.dropFunction( function_name, function_params, drop_options )

Drop a function - postgres docs

Arguments:

  • function_name [Name] - name of the function to drop
  • function_params [array] - see
  • drop_options [object] - options:
    • ifExists [boolean] - drops function only if it exists
    • cascade [boolean] - drops also dependent objects

pgm.renameFunction( old_function_name, function_params, new_function_name )

Rename a function - postgres docs

Arguments:

  • old_function_name [Name] - old name of the function
  • function_params [array] - see
  • new_function_name [Name] - new name of the function