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
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.