Postgres Subquery while inserting data

Question

I am trying to run a query in which a particular column value is a foreign key.

INSERT INTO tbl_test(group_id, test_name, test_code) VALUES (SELECT group_id FROM tbl_group
 where group_code = '6868' , 'test', '123');

This is my query. On executing this query i'm getting an error as

ERROR:  syntax error at or near "SELECT"
LINE 1: ... tbl_test(group_id, test_name, test_code) VALUES (SELECT group

I am not sure where i am doing wrong. Please help me on this.

wildplasser · Accepted Answer · 2014-01-02 09:13:52Z

1

You don't need the values(), you can just add the literals to the select's column list, like:

INSERT INTO tbl_test(group_id, test_name, test_code) 
SELECT group_id , 'test', '123'
FROM tbl_group
WHERE group_code = '6868'
  ;

answered Jan 2, 2014 at 9:13

wildplasser

44.5k9 gold badges72 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1