Hello, Why don't you simply use pg_dump with a format suitable for pg_restore ? You will not have to face the constraints of shapefile on columns names.
Regards, Hugues. -----Message d'origine----- De : [email protected] [mailto:[email protected]] De la part de Stephen Crawford Envoyé : lundi 13 octobre 2014 18:46 À : PostGIS Users Discussion Objet : [postgis-users] export Hello All, I want to copy a postgis table from one database to another. Is dumping to a shapefile the best way to do this? Any other method? Pros and cons? Thanks, Steve -- Stephen Crawford Center for Environmental Informatics The Pennsylvania State University _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
