Insert with copy past and join query

I wonder if I can do the following with DataGrip to insert datas in joint tables.

If I click on a table, I get the view of the datas. I can add rows and with copy and past insert fast values.

If I connect the tables with my query and get nice output table view... I can not add lines. Is there a way to get this...

Like to add row for my joined output and insert into joined tables values by copy past rows?


评论操作 固定链接

There is no way to do that. The view is read-only because it is not always a simple table, but more often a compilation from different tables, results of procedures execution, or even a static value.