Functions / System Administration Functions

pg_column_size

Shows the number of bytes used to store any individual data value.

Reading PG 18current·documented in 22 of 27 versions, 8.1 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_column_size ( "any" ) → integer

Shows the number of bytes used to store any individual data value. If applied directly to a table column value, this reflects any compression that was done.

Version history 2

12 → 13 changed
8.0 → 8.1 added

Definition snapshot: b7bd9cda · English manual source