title: Postgresql Data Types
tags: psql
h1:

These are not all the types available. Rather this is a list of ones that gets
amended as I need them. See [the official docs](https://www.postgresql.org/docs/current/datatype.html)
for something more comprehensive.

## Common
```csv sep=|
csvhead: Type|Description
integer|4 bytes, aka int32
bigint|8 bytes, aka int64
real|4 bytes, aka float
double precision|8 bytes, aka double
serial|4 bytes, autoincrementing int32
bigserial|8 bytes, autoincrementing int64

```

## Numeric
```csv sep=|
csvhead: Name|Storage Size|Description|Range
smallint|2 bytes|small-range integer|-32768 to +32767
integer|4 bytes|typical choice for integer|-2147483648 to +2147483647
bigint|8 bytes|large-range integer|-9223372036854775808 to +9223372036854775807
decimal|variable|user-specified precision, exact|up to 131072 digits before the decimal point; up to 16383 digits after the decimal point
numeric|variable|user-specified precision, exact|up to 131072 digits before the decimal point; up to 16383 digits after the decimal point
real|4 bytes|variable-precision, inexact|6 decimal digits precision
double precision|8 bytes|variable-precision, inexact|15 decimal digits precision
smallserial|2 bytes|small autoincrementing integer|1 to 32767
serial|4 bytes|autoincrementing integer|1 to 2147483647
bigserial|8 bytes|large autoincrementing integer|1 to 9223372036854775807
numeric(precision, scale)|?||Arbitrary Precision|
```

## Date/Time
```csv sep=|
csvhead: Name|Storage Size|Description|Low Value|High Value|Resolution
timestamp [ (p) ] [ without time zone ]|8 bytes|both date and time (no time zone)|4713 BC|294276 AD|1 microsecond
timestamp [ (p) ] with time zone|8 bytes|both date and time, with time zone|4713 BC|294276 AD|1 microsecond
date|4 bytes|date (no time of day)|4713 BC|5874897 AD|1 day
time [ (p) ] [ without time zone ]|8 bytes|time of day (no date)|00:00:00|24:00:00|1 microsecond
time [ (p) ] with time zone|12 bytes|time of day (no date), with time zone|00:00:00+1559|24:00:00-1559|1 microsecond
interval [ fields ] [ (p) ]|16 bytes|time interval|-178000000 years|178000000 years|1 microsecond

```
### Notes:
* `timestamptz` is accepted as an abbreviation for `timestamp with time zone`.

## Dummy Template
```csv sep=|
csvhead: Type|Description

```