[postgis-users] Selecting a Bounding Box for a whole table

[Nicolas Ribot]

> Hi ,
> I was trying to select a bounding box for a whole theme, which then includes all features within a table. However I am not sure how to use the "SELECT (BOX(the_geom)) from myTheme; " - command for a whole table.
> Could somebody tell me a hint?!
> 
> Thanks a lot!
> 
> Tom

Hi Tom,
You can use the extent() table function for that:

select extent(the_geom) from myTheme;

It returns a box2d object: the spatial extension of the whole dataset
for your table.
Nicolas