Is there a way to see PostgreSQL RAISE NOTICE output?

[susumantan]

Hi, I'm running a PostgreSQL function that uses RAISE NOTICE, for example:

CREATE OR REPLACE FUNCTION demo() RETURNS void AS $$
BEGIN
  RAISE NOTICE 'step 1 done';
  RAISE NOTICE 'step 2 done';
END;
$$ LANGUAGE plpgsql;

SELECT demo();

In TablePro I only get the result pane, and I can't find where the notices are shown.

Tablepro:

Is this supported and I've just missed it (a setting or a hidden panel), or are notices not displayed yet?

[g4lb]

Not yet in the normal editor. For PostgreSQL, only the Routine Debugger shows notices.

[datlechin]

Not yet, only the Routine Debugger shows them for now. I'm adding notices to the editor, they'll show in the Output view next to the result

[susumantan]

I see, thank you

[datlechin]

PR is landed #4061

[susumantan]

Thank you, sorry I couldn't help much for the PR. Much appreciated.