dpage
commented
8 years ago Comment migrated from Redmine: https://redmine.postgresql.org/issues/1439#note-1 Originally created by Daniel Ward at 2016-07-07 04:16:14 UTC.
Oracle SQL Developer has the same behaviour described by Franck. You press F5 to submit the entire script, or press F9 to run just the current statement. To implement, you simply trace backward until you encounter the first semicolon or the first forward slash. Then you trace forward until the next semicolon or forward slash. This lets you use forward slashes to separate code blocks. The reason I would use this function is to for when I interactively clean up user data - example - a properly formatted postal code may be entered, but when you lookup the address on a web service you see the postal code was entered incorrectly. To sift out the problem ones, I take the first few characters of the postal code and the city name and group them with a count. The one that is not like the others I investigate and then correct. This means I write out a series of different SQL statements, and execute a different statement depending on what I want to mine.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/1439 Originally created by Franck Dernoncourt at 2016-07-06 22:37:26 UTC.
In the query editor, it would be nice to have a keyboard shortcut to execute the statement at cursor. (e.g., MySQL Workbench, one can use the keyboard shortcut Ctrl + ENTER to execute the statement at cursor delineated with semi colons). F5 only executes the selected text, which means the user has to first select the text.