Difference between revisions of "Working with Databases"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
* '''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 | * '''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 | + | All these plugins use the same Connection selector<br> |
[[File:SelectConnection.png]] | [[File:SelectConnection.png]] | ||
| − | and the same way to configure a new connection | + | and the same way to configure a new connection<br> |
[[File:ConfigureConnection.png]] | [[File:ConfigureConnection.png]] | ||
Revision as of 01:40, 1 December 2012
back to New User Guide Index page
References
Database connection
There are several plugins in OpenJUMP, making 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
and the same way to configure a new connection
Connecting a layer to a table
Creating a layer from a query
Other resources
See also Plugins for OpenJUMP
PostgreSQL/PostGIS
- PostGIS Tutorial (for OpenJUMP + postgis plugin) (german) by Uwe Dalluege
- PostGIS Manual by Paul Ramsey in English
- Manual PostGIS - Spanish version by Manuel Martìn Martìn
- Introduction to PostGIS (English) from Postgres online Journal
- OpenJUMP for PostGIS Spatial Ad-Hoc Queries (English) by Regina Obe from Postgres online Journal
- OpenJUMP 1.3 Tutorial (English) by S. Steiniger, M. Michaud and Erwan Brocher for OGRS 2009.
- Mineral Targeting Exercise by Ravi Kumar
Oracle
- jumpdbplugin by Larry Reeder
MySQL
- jumpdbplugin by Larry Reeder
back to New User Guide Index page