Monday 3 February 2020

Exporting shapefiles from QGIS to PostGIS?


The tutorials I've been seeing such as this one https://saarapakarinen.wordpress.com/2015/06/13/tutorial-creating-a-postgis-database-for-qgis-part-2/


They mention a SPIT plugin that I can't find anywhere even after installing the WIEN version. DB Manager doesn't quite seem to do the same thing as described in the link above


Is there some other plugin to do the job?



Answer




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


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...