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” button in the toolbar. A parameter box will pop up if your function requires you to input parameters. This is the default layout of the debugger. Set the breakpoint in the Code pane. You can control the debugger using the Run, Step Over, Step In, Step Out, Step End and Stop buttons. There are several useful views to help breakdown the information. The “Breakpoints” view will display all of the breakpoints. The “Stacks” view will display the function calls of the current line. The “Data” view will display information about the variables. And finally, the “Watches” view will display information about the variables being watched. To add a variable to the Watch List, simply control-click the highlighted code and choose “Add to Watch List”. The bottom part of the debugger shows the log and the output of the function.
