On 2/16/21 5:44 PM, Tim Cross wrote:
Given the number, I think I would do the same. A good example of why
being 'lazy' can be a virtue. Faster and easier to write a procedure to
generate dynamic SQL than write out all those alter statements manually
or even write it using a scripting language and ODBC if there is
sufficient variation in the statements to make writing it in plsql
'messy'.
In my case, the statements are generated by Ora2Pg, and the DO blocks are
generated by a bash script I wrote. Input data can be messy, so want to
verify things before running.
Sure, vim is great at highlighting some problems, but certainly not all.
What I'm really looking for the PostgreSQL version of SQL Server's Ctrl-F5:
it runs just the parser and then stops,
--
Angular momentum makes the world go 'round.
