Re: postgres insert + select + values - Pgsql 9.5 - Mailing list pgsql-general

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