Postgres查询解决方案

Question

with FQuery as 
(
select ci_nm      as ci_nm 
,     ci_nm             as ci_alias_nm
from rpt.ci_d
),
SQuery as 
(
select ci_nm, ci_alias_nm from FQuery limit 10
)
insert into stg.Test1 (Select * from SQuery),
insert into stg.Test2 Select * from SQuery;

我正试图从第二个子查询中实现插入多个表。然而，它给出了一个错误"error:42601:在"insert"处或附近的语法错误">

Answer 1

不能有两个"主查询"。如果您想在两个表中插入相同的数据，那么您的数据库设计可能有问题。

Answer 2

如果您想一次进行两个查询，您应该使用事务。

BEGIN;
-- YOUR SQL STUFF
COMMIT;