pgsql打印执行结果

要在PL/pgSQL中打印执行结果，可以使用raise notice语句。在给定的示例中，存储过程p_demo()使用了raise notice语句来打印执行结果。在循环过程中，使用raise notice '执行：%，a'来打印每次循环的结果。最后，使用raise notice '最后执行结果：%，a'来打印最终的执行结果。这样，在执行存储过程时，会将结果打印到输出中。\[1\]
#### 引用[.reference_title]
- *1* [pgsql:简单存储过程使用while循环并打印出结果](https://blog.csdn.net/quan278905570/article/details/129966767)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [PostgreSql 的PL/pgSQL 块结构 （在pgAdmin查询工具中如何执行语句块）](https://blog.csdn.net/carcarrot/article/details/106338431)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [将pgsql执行的内容输出到文本文件中](https://blog.csdn.net/qq_42680332/article/details/116652904)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]