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?


1 comment

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. 



Please sign in to leave a comment.