postgresql insert from select query, plus static values

Question

I would like to INSERT into a table rows from another, specified by a SELECT DISTINCT, plus some static values, something like:

INSERT INTO new_tbl (column1, column2, column3)
SELECT DISTINCT id FROM -- long where clause --, 
  'a string', 0;

So that every row in the new table will get the same values for column2 and column3 Is this possible?

shx · Accepted Answer · 2016-03-14 09:34:53Z

up vote 1 down vote accepted

You can put static values into SELECT clause.

INSERT INTO new_tbl (column1, column2, column3)
    SELECT DISTINCT id, 'a string', 0 FROM -- long where clause --;

answered Mar 14 at 9:34

shx

52716

facepalm... how on earth was I not seeing this? select query too long ;) – Julian Rubisch Mar 14 at 9:55

add a comment |

1 Answer 1