pg的function引用字符串变量

quote_literal

'SELECT * from table1 where username = ' ||  quote_literal(name)  || '
    limit ' || page || ' offset ' || start ;

参考

• PLPGSQL-STATEMENTS-EXECUTING-DYN