postgres populate table from another table

Solutions on MaxInterview for postgres populate table from another table by the best coders in the world

showing results for - "postgres populate table from another table"
Anna
18 Nov 2016
1INSERT INTO TABLE1 (id, col_1, col_2, col_3)
2SELECT id, 'data1', 'data2', 'data3'
3FROM TABLE2
4WHERE col_a = 'something';
5
similar questions
queries leading to this page
postgres populate table from another table