test=*# create table demo2(demo_id int references demo, val text);
CREATE TABLE
test=*# with id as (insert into demo (val) values ('neuer test') returning id) insert into demo2 select id, 'das geht in demo2' from id;
INSERT 0 1
test=*# select * from demo;
id | val
----+------------
1 | test
2 | test
3 | neuer test
(3 rows)
test=*# select * from demo2;
demo_id | val
---------+-------------------
3 | das geht in demo2
(1 row)
test=*#