insert all
最近更新时间: 2025-02-18 16:02:00
postgres=# create table t5(f1 int,f2 int);create table t6(f1 int,f2 int);
CREATE TABLE
CREATE TABLE
postgres=# insert all into t5 values(f1,f2) into t6 values(f1,f2) select 1 as f1,1 as f2;
INSERT 0 2
postgres=# select * from t5;
f1 | f2
----+----
1 | 1
(1 row)
postgres=# select * from t6;
f1 | f2
----+----
1 | 1
(1 row)