Geometric
PostgreSQL Data Type Geometric
Categories:
| Type | Size | Description | Example |
|---|---|---|---|
| point | 16 bytes | Point on a plane | (x,y) |
| line | 32 bytes | Infinite line | {A,B,C} |
| lseg | 32 bytes | Finite line segment | ((x1,y1),(x2,y2)) |
| box | 32 bytes | Rectangular box | ((x1,y1),(x2,y2)) |
| path | 16+16n bytes | Closed path (similar to polygon) | ((x1,y1),…) |
| path | 16+16n bytes | Open path | [(x1,y1),…] |
| polygon | 40+16n bytes | ||
| Polygon (similar to closed path) | ((x1,y1),…) | ||
| circle | 24 bytes | Circle | <(x,y),r> (center point and radius) |