在shell脚本中使用postgres pgpl数据库连接代码块

    echo "BEGINNING OF $0 `date +'%Y-%m-%d %H:%M:%S'`"
    echo "plpgsql running"
    psql -h ${POSTGIS_IP}  -U ${PGUSER} -d ${POSTGIS_DB_NAME} <<EOF
    CALL public.pp();
    CALL public.cc();
    update aa set bb=1;
    do
$$
    declare
        rowcount integer;
    BEGIN
        update aa set bb=1;
        get diagnostics rowcount := row_count;
        raise notice 'update bts count is % ',rowcount;
        IF rowcount < 100 THEN
            COMMIT;
        ELSE
            ROLLBACK;
        END IF;
    END;
   
$$
LANGUAGE 'p