More than one console per database schema
I need to open more than one console for database schema.
Could be useful if I can open a new tab with a empty editor; write a query; connect with a database and execute the query having the results on a grid. Open a new tab with a blank editor and so on.
Is this possibile?
Thanks
Alessandro
Please sign in to leave a comment.
Hello.
Regarding multiple consoles please watch the request status: http://youtrack.jetbrains.com/issue/DBE-56
On opening empty editor: you can create an .sql file in your project, and start statements from that file with this or that data source. Alt+Enter on a statement in a file, select "Run Query in Console", select a data source. Then you can Ctrl+Enter on any more statement you like, or detach the data source in the status bar at the bottom.
Regards,
Alexander.
I'd prefer not to create a new file in advance. I'd prefer to open a new empty tab, write and run a query and after, if I need to, save the query.
Thanks.
Understood. Currently IDEA-based IDEs does not allow to "just open a tab", they open already created files for editing. Even the database console is a "file" internally.
I think you can create a feature request in our tracker to open a console not attached to any data source, and then attach it here or there.
Regards,
Alexander.