FUNCTIONS / SYSTEM ADMINISTRATION FUNCTIONS

pg_size_bytes

Converts a size in human-readable format (as returned by pg_size_pretty) into bytes.

Signatures & examples

pg_size_bytes ( text ) → bigint

Converts a size in human-readable format (as returned by pg_size_pretty) into bytes. Valid units are bytes, B, kB, MB, GB, TB, and PB.

Version history 3

PG 15 → 16changed
PG 12 → 13changed
PG 9.5 → 9.6added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source