postgresql insert from select

1 Answer. Sorted by: 7. You probably want. INSERT INTO foo (x, y) SELECT b1.id, 3 FROM boo b1; A literal value must go into the SELECT clause, it's not another table in the FROM clause. What can also work is. INSERT INTO foo (x, y) VALUES ( (SELECT b1.id FROM boo b1 WHERE …), 3 ); or. my love from the star pemain