[postgis-users] Making circles

[Nicolas Ribot]

>     I´m reading the WKT chapters in the PostGis Manual and there i can find
> constructors for basic geometries ( lines, polygons, and all stuff). I want
> to make a circle, so, is there any function or constructors for usually used
> geometry as circles, n-side-regular-polygons, etc..?
>     Thanks in advance,
>
>

You can achieve this with the buffer function acting on a POINT:

select astext(buffer(pointfromtext('POINT ( 5 5)', -1), 10, 8));

second buffer parameter (10) is the buffer distance, third (8) is the
number of segments to approximate the circle, per quadrant.

Nicolas