Geometric types v15

Suggest edits
NameNativeAliasDescription
POINT✅Point on a plane, 16 bytes storage, represented as (x,y)
LINE✅Infinite line, 32 bytes storage, represented as {A,B,C}
LSEG✅Finite line segment, 32 bytes storage, represented as ((x1,y1),(x2,y2))
BOX✅Rectangular box, 32 bytes storage, represented as ((x1,y1),(x2,y2))
PATH✅Closed path (similar to polygon), 16 + 16n bytes storage, represented as ((x1,y1),...)
PATH✅Open path, 16 + 16n bytes storage, represented as [(x1,y1),...]
POLYGON✅Polygon (similar to closed path), 40 + 16n bytes storage, represented as ((x1,y1),...)
CIRCLE✅Circle, 24 bytes storage, represented as <(x,y),r> (center point and radius)

Overview

Geometric data types represent two-dimensional spatial objects.

For more information on geometric data types, see the PostgreSQL documentation.

← Prev

Enumerated types

↑ Up

Data types

Next →

Network address types