Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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
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 по дате отправления: