SPIT Plugin¶

QGIS comes with a plugin named SPIT (Shapefile to PostGIS Import Tool). SPIT can be used to load multiple shapefiles at one time and includes support for schemas. To use SPIT, open the Plugin Manager from the Plugins menu, in the Installed menu check the box next to the SPIT and click [OK].

To import a shapefile, use Database ‣ Spit ‣ Import Shapefiles to PostgreSQL from the menu bar to open the SPIT - Shapefile to PostGIS Import Tool dialog. Select the PostGIS database you want to connect to and click on [Connect]. If you want, you can define or change some import options. Now you can add one or more files to the queue by clicking on the [Add] button. To process the files, click on the [OK] button. The progress of the import as well as any errors/warnings will be displayed as each shapefile is processed.

Figure SPIT Plugin 1:

Using SPIT Plugin to import Shape files to PostGIS