Working with Databases

back to New User Guide Index page

References

Database connection

Several plugins, in OpenJUMP, make use of DataBase connections

DataStore Layer available in Files > Open...
Run DataStore Query available in Files
Save As PostGIS available in the layer contextuel menu : write click on the layer, then choose Save Dataset As... and select the PostGIS table format

All these plugins use the same Connection selector

The right blue icon representing a DataBase open the Connection Manager

Adding a new connection open the following dialog box to configure the connection

To get more details about connection configuration, go to Configure a DataBase Connection

Connecting a layer to a table

To connect a Layer to a DataBase (AKA DataStore layer), choose the DataStore Layer option, in Files > Open... menu. Once a connection has been selected (see previous chapter), you can choose a table name and the database column containing the geometry to load as the feature geometry (a database table may have several geometries per feature).

Note that the plugin creates a dynamic layer. It means that each modification made in the view (zoom, pan...) will reload the data consequently. It also means that only data intersecting the viewport is loaded, an the OpenJUMP layer does not represent the whole table but only the part visible in the viewPort.