Hi; Create a new geometry column "the_geom_3763"
then run this UPDATE table_name SET the_geom_3763=transform(the_geom,3763), (You have now one table data in two projections. Then if you want, change the geometry column names "the_geom, the_geom_27492".) !!! don't forget to update also gemetry_columns table.... Regards, IBO... On Thu, Jan 21, 2010 at 1:22 PM, legio nostra <[email protected]>wrote: > Hello everyone, > > I have a database created with the program pgadmin3. The geo-referencing > system is the Datum 73 / Modified Portuguese > > Grid (deprecated) "EPSG: 27492" and wanted to change the whole database to > the coordinate system ETRS89 / Portugal TM06 (EPSG: 3763). > > How can I make this transformation? > > Thank you for your help > > -- bernardo -- > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
