may be qualified with a schema name pg_size_pretty(bigint) text Converts a size in bytes into a human-readable format with size units pg_column_size shows the space used to store any individual data toast tables. pg_size_pretty can be used to format the result of one of the other functions in a human-readable way, using kB, MB, GB or TB as appropriate. The functions shown in Table 9-48 provide native be archived until the tape is swapped. You should ensure that any error condition or request to a human operator is reported appropriately so that the situation can be resolved relatively quickly. The pg_xlog/

may be qualified with a schema name pg_size_pretty(bigint) text Converts a size in bytes into a human-readable format with size units pg_column_size shows the space used to store any individual data toast tables. pg_size_pretty can be used to format the result of one of the other functions in a human-readable way, using kB, MB, GB or TB as appropriate. The functions shown in Table 9-48 provide native be archived until the tape is swapped. You should ensure that any error condition or request to a human operator is reported appropriately so that the situation can be resolved relatively quickly. The pg_xlog/

be archived until the tape is swapped. You should ensure that any error condition or request to a human operator is reported appropriately so that the situation can be resolved relatively quickly. The pg_xlog/ 349 Chapter 26. Regression Tests forms, or even with different compiler optimization options. Human eyeball comparison is needed to determine the real significance of these differences which are usually Appendix A. This field is not localizable, and is always present. PG_DIAG_MESSAGE_PRIMARY The primary human-readable error message (typically one line). Always present. PG_DIAG_MESSAGE_DETAIL Detail: an optional

table; the sub-object ID is zero when referring to a whole object). This description is intended to be human-readable, and might be translated, depending on server configuration. This is useful to determine bigint Shorthand for pg_relation_size(..., ’main’) pg_size_bytes(text) bigint Converts a size in human-readable format with size units into bytes 361 Chapter 9. Functions and Operators Name Return Type expressed as a 64-bit integer into a human-readable format with size units pg_size_pretty(numeric) text Converts a size in bytes expressed as a numeric value into a human-readable format with size units

may be qualified with a schema name pg_size_pretty(bigint) text Converts a size in bytes into a human-readable format with size units pg_tablespace_size(oid) bigint Disk space used by the tablespace size in bytes. pg_size_pretty can be used to format the result of one of the other functions in a human-readable way, using kB, MB, GB or TB as appropriate. pg_total_relation_size accepts the OID or name be archived until the tape is swapped. You should ensure that any error condition or request to a human operator is reported appropriately so that the situation can be resolved relatively quickly. The pg_xlog/

may be qualified with a schema name pg_size_pretty(bigint) text Converts a size in bytes into a human-readable format with size units pg_tablespace_size(oid) bigint Disk space used by the tablespace size in bytes. pg_size_pretty can be used to format the result of one of the other functions in a human-readable way, using kB, MB, GB or TB as appropriate. pg_total_relation_size accepts the OID or name be archived until the tape is swapped. You should ensure that any error condition or request to a human operator is reported appropriately so that the situation can be resolved relatively quickly. The pg_xlog/

table; the sub-object ID is zero when referring to a whole object). This description is intended to be human-readable, and might be translated, depending on server configuration. This is useful to determine bigint Converts a size in human-read- able format with size units into bytes pg_size_pretty(big- int) text Converts a size in bytes ex- pressed as a 64-bit integer into a human-readable format with size units pg_size_pretty(numer- ic) text Converts a size in bytes ex- pressed as a numeric value into a human-readable format with size units pg_table_size(reg- class) bigint Disk space used by the specified

table; the sub-object ID is zero when referring to a whole object). This description is intended to be human-readable, and might be translated, depending on server configuration. This is useful to determine bigint Shorthand for pg_relation_size(..., ’main’) pg_size_bytes(text) bigint Converts a size in human-readable format with size units into bytes 340 Chapter 9. Functions and Operators Name Return Type expressed as a 64-bit integer into a human-readable format with size units pg_size_pretty(numeric) text Converts a size in bytes expressed as a numeric value into a human-readable format with size units

prone to small differences across platforms, or even with different compiler optimization options. Human eyeball comparison is needed to determine the real significance of these differences which are usually Appendix A. This field is not localizable, and is always present. PG_DIAG_MESSAGE_PRIMARY The primary human-readable error message (typically one line). Always present. PG_DIAG_MESSAGE_DETAIL Detail: an optional wants to access the object ever again. For that reason it is recommended to al- ways associate a human-readable comment with every object. Those can then be seen with the \lo_list command. Note that this

by catalog OID, object OID and a (possibly zero) sub-object ID. This description is intended to be human-readable, and might be translated, depending on server configuration. This is useful to determine expressed as a 64-bit integer into a human-readable format with size units pg_size_pretty(numeric) text Converts a size in bytes expressed as a numeric value into a human-readable format with size units the relation. pg_size_pretty can be used to format the result of one of the other functions in a human-readable way, using kB, MB, GB or TB as appropriate. The functions above that operate on tables or