Hi, Of course if you select * from a table where a column "the_geom" exists and perform in the same time some geometry computation with an alias named "the_geom" (i.e. "AS the_geom"), then you have two columns named "the_geom".
Best regards, Hugues De: "paul malm" <[email protected]> À: "PostGIS Users Discussion" <[email protected]> Envoyé: Jeudi 4 Juillet 2019 14:26:07 Objet: Re: [postgis-users] creating points from polygons, storing all attributes Thanks, I’ve tried that but get this error: ERROR: column "the_geom" is specified more than once SQL state: 42701 /Paul Från: postgis-users [mailto:[email protected]] För Derek Watling Skickat: den 4 juli 2019 13:55 Till: PostGIS Users Discussion Ämne: Re: [postgis-users] creating points from polygons, storing all attributes CREATE TABLE NewPointLayer AS SELECT *, ST_PointOnSurface(the_geom)::geometry(Point,32632) AS the_geom FROM OldPolygonLayer From: postgis-users <[email protected]> On Behalf Of [email protected] Sent: Thursday, 04 July 2019 13:47 To: [email protected] Subject: [postgis-users] creating points from polygons, storing all attributes Hi, I would like to create a point table from a polygon table. One point in each polygon Query = CREATE TABLE NewPointLayer AS SELECT ST_PointOnSurface(the_geom)::geometry(Point,32632) AS the_geom FROM OldPolygonLayer But how do I write the query to get all the attributes from OldPolygonLayer to the NewPointLayer? Thanks in advance, Paul _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
