Search Postgresql Archives

Re: postgres insert + select + values - Pgsql 9.5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux