
Geometric types in PostgreSQL represent two dimensional spatial objects. These types are not standard SQL data types,
and will not be discussed in depth in this book. Table 324 gives a brief overview of each of
the available geometric types.
Table 324. Geometric types
Type Name

Storage

Description

Syntax

point

16 bytes

A dimensionless object with no properties except for its location, where x and y are floatingpoint numbers.

(
x
,
y
)

lseg

32 bytes

Finite line segment. The points specified are the end points of the line segment.

((
x1
,
y1
), (
x2
,
y2
))

box

32 bytes

Rectangular box. The points specified are the opposite corners of the box.

((
x1
,
y1
), (
x2
,
y2
))

path

4 + 32 *
n
bytes

Closed path (similar to polygon). A connected set of
n
points.

((
x1
,
y1
), ...)

path

4 + 32 *
n
bytes

Open path. A connected set of
n
points.

[(
x1
,
y1
), ...]

polygon

4 + 32 *
n
bytes

Polygon (similar to closed path), with
n
end points defining line segments that makes up the boundary of the polygon.

((
x1
,
y1
), ...)

circle

24 bytes

The point (
x
,
y
) is the center, while
r
is the radius of the circle.

<(
x
,
y
),
r
>


