Plpgsql:如何在plpgsql中执行以下任务？

Question

- Server中的语法

SET @InnerQuery = @InnerQuery  + N'SELECT * from [' + @TableName + '] UNION ALL';

--在这里，我尝试在plpgsql中查询上述查询。

innerquery:= innerquery UNION ALL select * from '%',TableName; --Not in working state

Answer 1

试试这个：

execute innerQuery || ' union all select * from "'
    || tableName || '"';