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