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 AppCode, you can perform data manipulation and data definition operations with tables.
When you double-click a table in the Database tool window ( ), the table is opened in the editor in the Table view. For more information about the view, see View data.
In AppCode, each table opens in a separate tab. The following rules are applied to long tab titles:
The Always show qualified names for database objects option is now turned off by default. Tab names for objects are qualified if you open two tabs of objects with the same name. For example, if you open two
actor
tables from different schemas, the schema name is added in the tab name.If the data source has a name that is longer than 20 symbols, the name is truncated.
If you have only one data source, AppCode does not display the data source name in the tab name.
If a qualified object name has more than 36 symbols, it is truncated.
Topic | Table tasks |
---|---|
Create and delete | Describes how to create and delete a table. |
Modify | Describes how to modify a table structure, add descriptions for databases and tables, enable read-only mode for a table. |
Filter | Describes 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 data | Describes 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. |
Compare | Describes 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.
Currently, AppCode supports coordinates in the following formats: WKT, WKB, and PostGIS geometry 4326.
View geographical data with the Geo viewer
In the Database tool window ( ), double-click the table with geographical data.
Click the Show Options Menu icon () and select Show Geo Viewer.
Read the notification about possible risks of enabling JCEF. If you accept the risk, click Enable JCEF.
In the Restart Required window, click Restart Now.
After the restart, press ⌃F5 or reopen the table with geographical data.
Click the Show Options Menu icon () and select Show Geo Viewer.
Recover AppCode after enabling JCEF
Navigate to the config directory.
- Syntax
- %HOMEPATH%\.<product><version>\config\projects
- Example
- C:\Users\JohnS\.AppCode2021.1\config\projects
- Syntax
- ~/Library/Application Support/<product><version>
- Example
- ~/Library/Application Support/AppCode2021.1
- Syntax
- ~/.<product><version>/config/plugins
- Example
- ~/.AppCode2021.1/config/plugins
In the options directory, open ide.general.xml in a text editor.
Remove the following line:
<entry key="ide.browser.jcef.enabled" value="true" />