DataGrip 2020.1 Help

Tables

A database table is a structure that organises data into rows and columns. Data in a table is stored in a cell that is an intersection of a vertical column and horizontal row. The table has a specified number of columns, but can have any number of rows. With DataGrip, you can perform data manipulation and data definition operations with tables.

Working with tables
TopicTable tasks
Create and deleteDescribes how to create and delete a table.
ModifyDescribes how to modify a table structure, add descriptions for databases and tables, enable read-only mode for a table.
FilterDescribes how to filter data in a table.
FilterDescribes different modes of viewing data, how to transpose a table, synchronize the data that you see in the editor with the contents of the database.
View dataDescribes different modes of viewing data, how to transpose a table, synchronize the data that you see in the editor with the contents of the database.
CompareDescribes how to compare two table structures, or contents of two tables.

Using Geo viewer for geographical data in PostgreSQL

The Geo viewer is a graphic viewer that you can use to explore geospatial data in your database. The Geo viewer opens in the Services tool window. You can click rows to navigate to the corresponding area on the map or click a pin on the map to navigate to the corresponding row.

To detach the Geo viewer tab from the Services tool window, drag it from the Services tool window.

The Geo Viewer

View geographical data with the Geo viewer

  1. In the Database tool window (View | Tool Windows | Database), double-click the table with geographical data.

  2. Click the Show Options Menu icon (Show Options Menu icon) and select Show Geo Viewer.

  3. Read the notification about possible risks of enabling JCEF. If you accept the risk, click Enable JCEF.

  4. In the Restart Required window, click Restart Now.

  5. After the restart, press Ctrl+F5 or reopen the table with geographical data.

  6. Click the Show Options Menu icon (Show Options Menu icon) and select Show Geo Viewer.

  7. View geographical data with the Geo viewer

Recover DataGrip after enabling JCEF

  1. Navigate to the config directory.

    Syntax
    %HOMEPATH%\.<product><version>\config\projects
    Example
    C:\Users\JohnS\.DataGrip2020.1\config\projects
    Syntax
    ~/Library/Application Support/<product><version>
    Example
    ~/Library/Application Support/DataGrip2020.1
    Syntax
    ~/.<product><version>/config/plugins
    Example
    ~/.DataGrip2020.1/config/plugins
  2. In the options directory, open ide.general.xml in a text editor.

  3. Remove the following line: <entry key="ide.browser.jcef.enabled" value="true" />

Last modified: 15 June 2020