SHOW PROCEDURE STATUS

注意事项

N/A

功能描述

显示有关存储过程的信息。

语法格式

  1. SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr]

参数说明

参考SHOW FUNCTION STATUS

展示内容

参考SHOW FUNCTION STATUS

示例

  1. opengauss=# -- 创建存储过程
  2. opengauss=# create or replace procedure proc1() as declare genre_rec record; --声明记录类型
  3. opengauss$# begin
  4. opengauss$# for genre_rec in (select e1.ename from public.emp1 e1 join public.emp1mot e1m on e1.mgr = e1m.mgr)
  5. opengauss$# loop
  6. opengauss$# raise notice '%', genre_rec."ename"; --打印
  7. opengauss$# end loop;
  8. opengauss$# end;
  9. opengauss$# /
  10. CREATE PROCEDURE
  11.     opengauss=# -- 查看信息
  12. opengauss=# show procedure status like 'proc%';
  13.    Db   | Name  |   Type    | Definer |           Modified            |            Created            | Security_type | Comment | character_set_client | collation_connection |Database Collation
  14. --------+-------+-----------+---------+-------------------------------+-------------------------------+---------------+---------+----------------------+----------------------+--------------------
  15.  public | proc1 | PROCEDURE | wyc     | 2022-09-24 14:46:40.868293+08 | 2022-09-24 14:46:40.868293+08 | INVOKER       |         |                      |                      |en_US.UTF-8
  16. (1 row)