[postgis-users] Create new column with other SRID
lisek.lichu at gmail.com
Fri Oct 31 08:19:17 PDT 2008
Hello i have a little problem creating a new column for my table and
inserting there new data.
I have a talbe:
CREATE TABLE "axes" (
gid serial PRIMARY KEY,
and this table if full of data
now i want to add new column with another SRID like wgs84 srid = 4326
and now i need to create a query that reads each row from column the_geom,
converts it by Transform(the_geom, 4326) and put into a new kolumn
the_geom_wgs84 in the same row.
Do You have an idea if it is possible?
I tried to do something like that:
INSERT INTO "axes" (the_geom_wgs84) VALUES (select
AsText(Transform(the_geom,4326)) from axes)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users