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,
"name" varchar(100));
SELECT AddGeometryColumn('','axes','the_geom','27492','LINESTRING',2);
and this table if full of data
now i want to add new column with another SRID like wgs84 srid = 4326
SELECT AddGeometryColumn('','axes','the_geom_wgs84','4326','LINESTRING',2);
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:
SELECT AddGeometryColumn('','axes','the_geom_wgs84','4326','LINESTRING',2);
INSERT INTO "axes" (the_geom_wgs84) VALUES (select
AsText(Transform(the_geom,4326)) from axes)
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
