I’m relatively new to both PL/pgSQL and Supabase, and I’m currently working on debugging my code within the Supabase SQL editor. I’d like to know how I can print or similiar function in the SQL editor specifically for debugging purposes. Could someone provide suggestions or best practices for achieving this?

Here’s a simple example function I’ve tried :

create
or replace function print_example () returns text language plpgsql as $$
begin
    raise notice '%', 'hello world';
    return '';
end;
$$;

select
  print_example ();

I can’t seem to locate where the result is displayed.

its not show in result.

i cant find it in pg log.

Any guidance on this matter would be greatly appreciated as this simple function would come in very handy for my debugging process.

Thank you!