Get Extent of Table

PL/pgSQL

SELECT ST_XMax(r) AS xmax, ST_XMin(r) AS xmin, ST_YMax(r) AS ymax, ST_YMin(r) AS ymin FROM  (SELECT ST_Collect(geom) AS r FROM bc.bc_roads) AS foo;