匿名块如何接收外部传入参数

方法一：

通过ksql -v 

?

1 2 3 4 5 6 7 8 9 10 11 12 13

[kingbase@singlekbdb ~]$ ksql -Usystem -p54321 test -v id=2 -c '\i 1.sql;' ksql:1.sql:9: 注意:  time is 2020-09-18 00:00:00 ANONYMOUS BLOCK   [kingbase@singlekbdb ~]$ vi 1.sql \set SQLTERM / DECLARE        v_date date; BEGIN        select nd into v_date from t2 where id = :id;        raise notice 'time is %',v_date; END; /

 

方法二：

test=# \set id 2
test=#
test=# DECLARE
test-#        v_date text;
test-# BEGIN
test-#        select name into v_date from t1 where id = :id;
test-#        raise notice 'time is %',v_date;
test-# END;
test-# /
NOTICE:  time is bbbbbbbb
ANONYMOUS BLOCK
Time: 0.833 ms
test=#