PostgreSQL How to insert many record with one Insert statement

Question

I have a table, that all other columns have the same values, only one difference, this column is result from another select statement.

I need somethings like

INSERT INTO my_table (orgid, status, userid )
    VALUES(12393, true, SELECT u.userid FROM user u)

I can use a loop statement with many insert statement inside, but i want something more easy, 1 sqlQuery and dont use of functions :-?

Iswanto San · Accepted Answer · 2013-03-02 07:33:26Z

4

Try this :

INSERT INTO my_table (orgid, status, userid )
SELECT 12393, true, u.userid FROM user u

answered Mar 2, 2013 at 7:33

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

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

1 Answer 1