Ravi Krishna schrieb am 20.03.2020 um 15:48:
How do we get the notification mentioned in RAISE INFO of PL/PGSQL in JDBC.
I can get it in psql, but not in JDBC.
I am talking about redshift which has the same procedural language like
postgres.
I can only answer this for Postgres.
As Redhisft has its own JDBC driver, I don't know if this applies to that as
well:
All messages from a RAISE are reported as SQL Warnings on the Statement
instance that you used.
So you can use Statement.getWarnings() to retrieve the RAISE output.
Note, that you need a loop that checks SQLWarning.getNextWarning() to find out
if there was more than one RAISE
Thomas
