Functions / System Administration Functions

pg_size_bytes

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

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

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

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

Definition snapshot: b7bd9cda · English manual source