PostGIS – How do you import an ESRI Geodatabase into PostGIS?

By David Crowther 

Question:

I would like to import the tables within an ESRI Geodatabase into my PostGIS database, what are the best steps to do this?

Answer:

In the blogs below, I start to discuss using the GDAL – Ogr2Ogr – tool to import and export between common spatial formats. With Part 2 concentrating on working with PostGIS.

Part One - https://www.cadlinecommunity.co.uk/hc/en-us/articles/115003496349-Utilising-Ogr2Ogr-Part-One

Part Two - https://www.cadlinecommunity.co.uk/hc/en-us/articles/115003798085-Utilising-Ogr2Ogr-Part-Two-PostGIS-

Below is an Ogr2Ogr statement that will load your ESRI Geodatabase tables into PostGIS.

ogr2ogr -f "PostgreSQL" PG:"host=servername port=5432 user='username' password='password' dbname='PostGISDBName'" D:/TEMP/geodb/parcels.gdb -overwrite -progress --config PG_USE_COPY YES

The above script will copy the tables within the parcels.gdb into the chosen PostGIS Database, so that it can be accessible using QGIS.