Re: postgres insert + select + values - Pgsql 9.5

2016-09-16 10:07 GMT+12:00 Patrick B <patrickbakerbr(at)gmail(dot)com>:

>
>>
>> A select can make up columns too, not just what you've got in a table,
>> so you can:
>>
>> select j_id, 'test-1 - comments' as comment from test2 where
>> customer_id=88897;
>>
>> and then you can simply insert that into your other table (you don't
>> need to specify the columns that are getting a default value):
>>
>> insert into test1 (j_id, comments)
>> select j_id, 'test-1 - comments' as comment from test2 where
>> customer_id=88897;
>>
>> https://www.postgresql.org/docs/current/static/sql-insert.html has more
>> info.
>>
>>
> Thanks Chris!
>
> But the problem is that test2 table has 180 rows with different j_id and I
> need to insert each one of them into test1 table.
>
> How can I do that?
> select j_id FROM test2 - will return 180 rows
>
>

Please have a look on this example Patrick:
http://sqlfiddle.com/#!15/1773d/4

Lucas