Re: Syntax checking DO blocks and ALTER TABLE statements?

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.