CockroachDB pg_column_size retuning null

Question

I am currently using the pg_column_size to calculate the size of a row in the DB. something like:

select pg_column_size(col1, col2, col3..... col10) from _table

Problem is when 1+ column value is null the whole function returns null.

Is there anyway to set a default value for each column within the function to avoid getting null?

Answer 1

try

select pg_column_size(<table_name>.*) from <table_name>;