import

Hello!  From this post you'll find out what's new in DataGrip 2017.1. It is a long read, so let's begin with the table of contents. Database tree: New schema management, SQL resolution scopes; Create database/schema UI; Color settings affects editor and grid. Import/export data: Column mappings and DDL preview; Drag-n-drop tables; Export result-set to a database. Query Console: Respecting the default search path in PostgreSQL; Trigger generation pattern; Insert string concatenation on Enter option;  Settings for Qualifying objects and more. Database objects: Double-cliсk ope

Hello! It’s time for the new EAP build for 2017.1 which is going to be released later this March. There are several notable features, let’s take a look at them. Schema management We are still working on the schema selection UI. Now it’s a tree with the ability to choose the current schema. Of course, if the current schema is changed in some other place, DataGrip will show the new one. The Schemas tab comes back to the data source properties dialog. We added the Pattern field where you can describe what you want to be introspected. The Ctrl+Q (Ctrl+J for OSX) shortcut will give you

Hello! The new year has already brought us a new version of DataGrip, as today we start the Early Access Program for DataGrip 2017.1. Everybody can try this free build and take the new possibilities for a spin: - Сolumns mapping in CSV - Drag-n-drop tables - Smart options for SQL editing - Code insight - SQLite introspection - Miscellaneous Let’s see what these enhancements are about. Сolumns mapping in CSV import Many users have asked us to make the import process more flexible. It frequently happens that the number of columns in a .csv file is not the same as in the target table

We are rapidly approaching the 2016.2 release in July. In the meantime, for those who are impatient to try the new features, we've got a new EAP build. Lots of people told us that the current way of importing CSV files (with the help of Edit As Table) was not very convenient. You asked, we delivered! Enjoy a dedicated UI for importing CSV, TSV (well, DSV) files to the database. Click the schema you want import data to, and choose Import From File... from the context menu. Then choose the CSV file where your data is. You will see the Import dialog window. The left-hand panel is for