PostgreSQL circle() Function

The PostgreSQL circle() function constructs a circle from the center point and radius.

circle() Syntax

This is the syntax of the PostgreSQL circle() function:

circle(point, radius) -> circle



Required. The center point of the circle. For example: point '(1,1)'.


Required. The radius of the circle. A value of type double.

Return value

The PostgreSQL circle() function returns a circle constructed from the center point and radius.

circle() Examples

The following statement shows how to use the PostgreSQL circle() function to construct a circle with the center point (1,1) and radius of 1.

SELECT circle(point '(1,1)', 1);