Menu
When you run a query (a SELECT statement) in the console, the data retrieved from the database are shown in table format in the Result pane of the Database Console tool window.
I've searched through datagrip Help and I'm just wondering if there is anyway out there that can be used to generate INSERT INTO scripts for a tables' content or rows in table format?
661
Bookmark this question. Show activity on this post. When you run a query (a SELECT statement) in the console, the data retrieved from the database are shown in table format in the Result pane of the Database Console tool window.
In the list of objects, select the object that you want to create. Right-click a directory of the DDL data source in the Files tool window (View | Tool Windows | Files) and select New | SQL File.
Choose SQL Insert extractor in the drop-down menu.
Them you'll be able to copy (Ctrl/Cmd+C) data as a bunch of INSERTS. Or use Export button next to the extractor.
126
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
