Navicat PostgreSQL Debugger can help you with the testing and debugging of PL/PGSQL functions.
To start debugging, open the design form of a function and click the “Debug Function” button in the toolbar.
This is the default layout of the debugger. Set the breakpoint in the Code pane. Click the “Run” button. A parameter box will pop up if your function requires you to input parameters. You can control the debugger using the Step Over, Step In, Step Out and Stop buttons
There are several useful views to help breakdown the information. The “Breakpoints” view will display all of the breakpoints at the bottom screen. The “Call Stack” view will display the function calls of the current line. The “Local Variables” view will display information about the variables. The “Parameters” view will display information about the inputted parameters.
And finally, other tabs show the message log and the output of the function.
