Online Documentation for SQL Manager for PostgreSQL
Use the Procedure tab of Procedure Editor to create/edit a procedure and specify its definition.
Select a schema and enter a name for the new procedure, or modify the name of the procedure being edited.
Select the language that the procedure is implemented in: SQL, C, internal, or the name of a user-defined procedural language.
The Arguments list provides the following attributes of each argument used in the function:
Type (the argument data type)
Mode (in, out, in/out)
Set the procedure arguments by right-clicking in the list and selecting Add Argument. Once the argument is added, select its type from the Argument Type drop-down list. To delete the existing argument, select Delete Argument from the popup menu. To reorder the arguments within the list, use the Move Up and Move Down items or the corresponding Ctrl+Up/Ctrl+Down shortcuts.
This area allows you to set the procedure definition (body).
For your convenience the syntax highlight, code folding, using macro and a number of other features for efficient SQL editing are implemented. For details see Working with Query Data area, Using the context menu and .