[postgis-users] Appending geometry data from another table

[Bruce Rindahl]

I have an existing table that I want to append new data from another table.
I can't figure out how to append the geometry.  My query looks something
like this:

INSERT into county_parcels SELECT
'Archuleta' as county,
the_geom as the_geom
 FROM county_temp;

The error is:

ERROR:  column "the_geom" is of type geometry but expression is of type
character varying
HINT:  You will need to rewrite or cast the expression.

How do I cast the geometry from the first table to insert into the second
one?

Thanks
Bruce Rindahl