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.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных