PostGIS Connections actions¶

Adds a new PostGIS connection. The connection is not defined through the usual QGIS connection dialog, but a custom one:

At the moment, this dialog does not allow to configure all the parameters that can be set up through the built-in dialog. Also, passwords and user names are always stored in this case. If this doesn’t fit your needs, create the new connection through the usual interface, using the Add PostGIS layers menu entry and then creating a new connection. Then refresh the PostGIS connections entry, since it will not be automatically updated.

Edits the connection parameters of the PostGIS connection. This also alters the definition of the connection in the general list of PostGIS connections kept by QGIS, not just for OpenGeo Explorer. You can also edit this using the Add PostGIS layers QGIS command, but the tree will need to be manually refreshed.

When a connection is edited using OpenGeo Explorer, the user name and password are stored. Use the QGIS UI instead if you want to edit the connection but not store the password. You will need to enter it each time you start the Explorer or refresh the PostGIS branch in the OpenGeo Explorer tree.

Imports a set of files with data into the selected schema. The following window is shown:

Click the button in the Layers group and select the files you want to import, then select the destination schema and table. You can select the name of a preexisting table or enter a new name. In case of selecting a preexisting table, click the Add to table checkbox can append the imported data to the existing content of the table. Otherwise, the table will be deleted and a new one with that name created.

If you select the Add to table box, data will only be imported if the feature type of the file to import matches the table feature type. If not, an error message will be shown in the log window and the corresponding file will not be imported.

There is an additional option, [use file name], which will set the table name based on the name of the file to import (without extension). The Add to table box applies also in this case.

When two or more files are selected, the Add to table box will automatically be checked in case a table name option other than [use file name] is selected.

When using the Add to table option, all imported layers should have a feature type compatible with that of the table to which they are going to be added. If feature types are not compatible, PostGIS will refuse to add the layer and raise an error.

This command supports only vector layers.

You can check “Import as single geometries” box to force all geometries to be imported as single geometries instead of multi-geometries. All features with multiple geometries will be automatically converted.

If the import is done using the Add to table option, the import relies on the shp2pgsql utility, which will need to be installed and on the PATH.

Creates a new table. The table definition is done in the following dialog: