[postgis-users] Need a "polygon box" of a table instead of the bounding box that returns extent function
nicolas.ribot at gmail.com
Wed May 5 07:23:13 PDT 2010
> What I want to do is an insert of the type INSERT INTO...VALUES .. as
> INSERT INTO boundaries ( the_geom, the_name ) VALUES
> My problem is that I want to replace the some_geometry_data value by the
> result of the SELECT query. And of course I am not an expert user of SQL
> statements so I don't know how to do that..
> from my_street_table;
> Maybe your example can work, I will try it later and let you know.
> INSERT INTO boundaries ( the_geom, the_name ) SELECT
> ST_ConvexHull(ST_Collect(the_geom)) as the_geom, 'mytablename' from
So yes, the example, (or, better, the link to the INSERT command
reference) will help you with the query.
(When inserting with a SELECT, the VALUES keyword is not used).
More information about the postgis-users