I have two tables with an identical structure of columns in CartoDB. Both are georeferenced.

I'd like to combine the date of the two tables into one table. In the options menu of CartoDB there is an option 'Append data...', which seems to be not activated.

How to proceed in this case?


You could just do

insert into table2 select * from table1

using the SQL console of the CartoDB editor


Make sure the fields match identically in name and type across the tables you want to append. Then use the SQL console.

INSERT INTO master_database (the_geom, field1, field2, field3, etc)
SELECT the_geom, field1, field2, field3, etc
FROM current_database;

jorgeas80 set me on the right track but when I attempted to follow his advice, I got the following error:

column "created_at" is of type timestamp with time zone but expression is of type text cartodb

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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