[postgis-users] PostGIS generic dumper/loader

[Regina Obe]

Lots of alternatives. 

1) You can use pg_dump / pg_restore if you are dumping PostGIS data and restoring to another PostGIS enabled database
2) You can use ogr2ogr which will allow you to transfer data from any data source to another data source (also supports non-spatial though it's primarily used for spatial)
3) My favorite - ogr_fdw -- Spatial foreign data wrapper - think of this as ogr2ogr in your PostgreSQL database -- it uses the same plumbing as ogr2ogr under the hood but allows you to query ogr'd data sources as if they are PostgreSQL tables.

4) If you are looking for a WYSIWYG thing -- QGIS Db Manager is pretty decent and can walk you thru loading / dumping - I think it too uses ogr under the hood.

There are tons more I can spout out but those I think are the most accessible and all open source and free.  

> -----Original Message-----
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> Behalf Of Diego Vargas
> Sent: Monday, February 24, 2020 3:05 PM
> To: postgis-users at lists.osgeo.org
> Subject: [postgis-users] PostGIS generic dumper/loader
> 
> Hi all,
> 
> Are there any alternatives for the pgsql2shp / shp2pgsql for dumping /
> loading gis data?
> 
> 
> Thanks!
> 
> Diego
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users