Stored Code Debugger

Database Workbench comes with a powerful Stored Code Debugger tool. You can reach this tool by using the context menu in the Database Navigator on sql or plpgsql based Stored Functions and selecting Debug Function. Alternatively, use the Debug buttons in the object editors.

Read the generic topic on the debugger first.

Note:

In order to use the Debugger, you need to install the PostgreSQL debugger module, information can be found here.

Testing procedure results

By using the SQL button on the toolbar, you can start an SQL Editor that uses the same transaction as the debugger. With this SQL Editor, you can test your procedure result (eg: INSERTs or DELETEs) before COMMITting or ROLLING back the transaction.