I have two tables (in CartoDB/PostGIS) that are from two tiger shapefiles that have the exact same attributes, just in different counties. I want to combine them in to a single table, just appending the data from one to the other. What is the SQL call to do that?
Presuming you have two datyasets with the same attributes:
you can combine them like this:
CREATE TABLE combined AS( SELECT id, city, geom FROM test_points1 UNION SELECT id, city, geom FROM test_points2)
and the result is the combined table: