[postgis-users] postgis table from another postgis table in different projection?

[Rasmus Aveskogh]

CREATE TABLE new_table AS
	SELECT ST_Transform(geometry, new_srid), other_columns FROM old_table;

-ra

On 16 Nov 2014, at 13:27, Ahmet Temiz <ahmettemiz88 at gmail.com> wrote:

> How can I create  postgis table from another postgis table in different projection?
> 
> regards
> 
> 
> -- 
> Ahmet Temiz
> Jeoloji Müh.
> Afet ve Acil Durum Yönetimi Başkanlığı
> Planlama ve Zarar Azaltma Dairesi Başkanlığı
> 
> 
> ________________________
> 
> Ahmet Temiz
> Geological Eng.
> Information Systems - GIS Group
> Disaster and Emergency Management
> of Presidency
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users