Exporting shapefiles from QGIS to PostGIS?

In 2.8 - 2.14 (Not sure about earlier versions) you can export shape files to PostGIS using the build in DB Manager.

  1. Open DB Manager enter image description here
  2. In the list of PostGIS databases find the one you want to export to, find the desired schema and pres the button marked with the red outline. enter image description here
  3. Choose the shape file in 'input' (Has to be in your 'Layers Panel') and press 'ok' enter image description here

That's it. Your shape file is now a table in PostGIS.

EDIT I see that this question has actually already been answered in this link


There is a tool bundled with PostGIS 2.2:

PostGIS 2.0 Shapefile and DBF Loader Exporter

It allows you to import and export.


The "SPIT" plugin is no longer bundled with QGIS, as the plugin was unmaintained and has been surpassed by DB Manager and the processing database import algorithms.

changelog.qgis.org/

enter image description here