Is there a way to set displaying messages in LOG in real time. As an example I have a long running function in Postgres which is displaying messages, in PG Admin I can read this messages immediately but in dbvisualizer I have to wait till the function finishes to have LOG displayed, which is not suitable for me since I can have functions that can run for hours and I need to see those messages immediately to see what is happening.
What type of output does the function generate, result set or just plain text output?
Would be great if you can share a sample function that produces the output and we will have a look.
Nothing special just using
raise notice 'message to display';