Am 13.03.19 um 20:25 schrieb David Raymond:
>
> ...but inserts into different tables need to be done in different statements.
you can insert into 2 tables within 1 statement using writeable common
table expressions (wCTE):
test=# create table table1(a int, b int, c int);
CREATE TABLE
test=*# create table table2(a int, b int, c int);
CREATE TABLE
test=*# with x as (insert into table1 values (1,2,3) returning *) insert
into table2 select * from x;
INSERT 0 1
test=*# select * from table1;
a | b | c
---+---+---
1 | 2 | 3
(1 row)
test=*# select * from table2;
a | b | c
---+---+---
1 | 2 | 3
(1 row)
test=*# with x as (insert into table1 values (4,5,6) returning *) insert
into table2 select * from x;
INSERT 0 1
test=*# select * from table1;
a | b | c
---+---+---
1 | 2 | 3
4 | 5 | 6
(2 rows)
test=*# select * from table2;
a | b | c
---+---+---
1 | 2 | 3
4 | 5 | 6
(2 rows)
test=*#
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
