SQLWorkBench

SQLWorkBench/J connecting to multiple users/sessions simultaneously – use SQLWorkBench – File – New Window

Another important feature of SQLWorkBench that I came across while testing my stored procedures with SQLWorkBench is the File -> New Window function which allow me to open several sessions simultaneoulsly connected with SQLWorkbench with different users connected. Thomas Kellerer – SQLWorkBench Author – helped me with that one.  Thank you Thomas Kellerer

Using SQLWorkBench for Redshift Stored Procedures

Using SQLWorkBench for Redshift Stored Procedures When writing Redshift stored procedures pl/pgsql,  it appears sqlworkbench/j does not return any type of “raise” statement to the user within SQLWorkBench which makes it very hard to debug…  Thank fully, there is a workaround. That is: you can query the redshift view: SVL_STORED_PROC_MESSAGES.  Which does record all raise …

Using SQLWorkBench for Redshift Stored Procedures Read More »

SQLWorkBench/J starting a new instance

SQLWorkBench/J starting a new instance… As Thomas says below, you don’t have to start a new instance instead, do a File -> New Window But if you did want a separate instance, here is what Thomas (Author of SQLWorkBench/J) says about that: Thomas Kellerer https://groups.google.com/g/sql-workbench/c/pG_DC6OeoXk Running multiple instances only makes sense if you also want …

SQLWorkBench/J starting a new instance Read More »