postgresql怎么打印错误信息

do

$$

declare

v_num int ;

v_text1 text;

v_text2 text;

begin

   v_num:=1/0;

exception when others

    then get stacked diagnostics v_text1= MESSAGE_TEXT,

                                 v_text2=PG_EXCEPTION_CONTEXT;

    --raise notice '异常:%,%',sqlstate ,sqlerrm;

    raise notice '异常:%,%',v_text1,v_text2;

end;

$$;

--其中,PG_EXCEPTION_CONTEXT会报告具体的错误行;排查错误很方便;