/pg_xtypes

Convenience types for PostgreSQL

Primary LanguageCApache License 2.0Apache-2.0

Convenience types for PostgreSQL

This repository contains a bunch of convenience types for PostgreSQL.

The bytes type

Byte size type, printing in the same way as pg_size_pretty, but also supporting arithmetics. It accepts a number followed by any of the following suffixes, which will scale it accordingly.

Name Symbol Value
kibibyte KiB 210
mibibyte MiB 220
gibibyte GiB 230
tebibyte TiB 240
pebibyte PiB 250
exbibyte EiB 260

The size is stored internally as a 64-bit unsigned integer, meaning that the maximum size that can be stored is 16 EiB (exbibyte).