Question

postgresql的"函数"怎么导出脚本

Answer 1

两种方法：
方法一：查询pg_proc:

osdba=# select prosrc from pg_proc where proname='get_username';
prosrc
--------------------------------------------------------

declare
ret text;

begin
SELECT name into ret from tang01 where id=userid;
return ret;

end;

(1 row)

方法二：调用pg_catalog.pg_get_functiondef函数：
osdba=# select pg_get_functiondef('get_username'::regproc);
pg_get_functiondef
----------------------------------------------------------------

CREATE OR REPLACE FUNCTION public.get_username(userid integer)
RETURNS text
LANGUAGE plpgsql

AS $function$

declare
ret text;

begin
SELECT name into ret from tang01 where id=userid;
return ret;

end;

$function$