October 2001
Beginner to intermediate
400 pages
7h 45m
English
The following is a table with the PostgreSQL built-in data types sorted according to what type of data they hold. This chart might be useful if you know the type of data you want to store but are unsure of the PostgreSQL designation for that data type.
| Data Category | PostgreSQL Data Type (Alias Name) | Description |
|---|---|---|
| Geometric | BOX | Coordinates describing a rectangle. |
| CIRCLE | Coordinates describing a circle. | |
| LINE | Coordinates describing an infinite line. | |
| LSEG | Coordinates describing a line segment. | |
| PATH | Coordinates describing a list of points. | |
| POINT | Coordinates describing a single point. | |
| POLYGON | Coordinates describing a polygon. | |
| Logical Network | BOOLEAN | True or false Boolean value. |
| CIDR | IP / size of network segment. | |
| INET | IP address ... |
Read now
Unlock full access