ALTER TABLE :table ALTER COLUMN latitude TYPE double precision USING latitude::double precision; ALTER TABLE :table ALTER COLUMN longitude TYPE double precision USING longitude::double precision; ALTER TABLE :table ALTER COLUMN error_km TYPE double precision USING error_km::double precision;