I have a local PostGIS database with a polygon table and a nonspatial table. I would like to upload them into my CartoDB account. What is the best way to do this? I could export the polygon layer as a shp and the nonspatial table as a csv then upload them like that, is that the most straightforward way? Or is there a way to skip that and copy directly from postgis to postgis?

1 Answer 1


I have used the following:

1) Export as a .SHP, zipped, then imported

2) Using GDAL / OGR2OGR as per Paul Ramsey's blog post:


  • this option will allow you to connect directly from your PostGIS table, and run the GDAL command to truncate and load your data...

3) The CartoDB QGIS Plugin will now allow you to upload data to your CartoDB account from QGIS

  • Thanks. The ogr2ogr seems like a good option if you want to set up a regular update process.
    – kmack
    Commented Nov 4, 2015 at 22:09
  • @kmack added a new one - the CartoDB QGIS plugin now supports uploading tables to your cartodb account through QGIS Commented Nov 5, 2015 at 23:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.