View data

Data view modes

You can browse and edit table data in three modes: Table, Tree, Text, and Transpose. To switch between these modes, click the View as button () and select the mode that you need.

• Transpose: viewing mode in which rows and columns are interchanged. You can combine this checkbox with other viewing modes.

  To make this mode a default for tables and views, open settings by pressing Ctrl+Alt+S and navigate to Tools | Database | Data Views and select the Automatically transpose tables. When this option is enabled, query results are not transposed.

  

• Table: the default viewing mode of table data. Data in a table is stored in a cell that is an intersection of a vertical column and horizontal row.

  

• Tree: viewing mode in which data is displayed in the key-value table with the possibility to expand the key cell if it contains children nodes. Data from the expanded children node is distributed between key and value columns. You might consider using this mode to work with JSON and array data.

  

• Text: viewing mode in which data is displayed as a text.

  

Value editor

Value editor is a separate editor where you can edit data that is stored in the cell. To open Value editor, in the cell context menu select Open in Value Editor.

If you store one-line JSON in a cell, you can click the Toggle Formatting icon. This action formats one-line XML and JSON strings.

Also, you can preview images in the value editor.

Note that to leverage the performance issues, the default LOB size is limited to 1024 bytes. It means that only 1024 bytes are loaded to the table editor. To increase this size and view larger images, open settings by pressing Ctrl+Alt+S, navigate to Tools | | Data Editor and Viewer, and change the value of the Maximum number of bytes loaded per value option.

Aggregate view

In the Aggregate view, you can select values of multiple cells and get a single summary value. To open Value editor, in the cell context menu select Show Aggregate View.

Click the gear icon on the toolbar of the Aggregates tab to view, enable, and disable aggregates. Also, you can create your own aggregate scripts. Bundled scripts are located in Scratches and Consoles | Extensions | Database Tools and SQL | data | aggregators. To add your own aggregator, place your script to the aggregators directory.

tip

Aggregate scripts and extractors are interchangeable. If you have previously used an extractor that gets just one value, you can copy it to the aggregates directory and use it for aggregates.

Using Geo viewer for geographical data in PostgreSQL

warning

The Geo data viewer works only if JCEF is enabled. In rare cases, when you enable JCEF, AppCode might crash. It can happen if you have installed plugins that use JavaFX. If the crash happened, see Recover AppCode after enabling JCEF.

note

To work with geographical data, you must install the Postgis extension on your PostgreSQL server. For more information about installation process, see the Postgis documentation.

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.

Currently, AppCode supports coordinates in the following formats: WKT, WKB, and PostGIS geometry 4326.