local-pg-2cartodb

localpg2cartodb

COPY
(SELECT beliggenhedsadresse_kommune_kode, count(*) as antal
 FROM cvr.virksomheder 
  WHERE beliggenhedsadresse_kommune_kode <> ''
   GROUP BY beliggenhedsadresse_kommune_kode
   ORDER BY antal DESC)
 TO PROGRAM 'cat <&0 > /tmp/data.csv; curl -F "file=@/tmp/data.csv;filename=cartodbtablename.csv" "https://{CARTODB_USER}.cartodb.com/api/v1/imports/?api_key={APIKEY}"'
   DELIMITER ',' 
   CSV HEADER;