How to replace nulls with zeros in postgresql crosstabs

You can use coalesce:

select account_number,
       coalesce(Attr1, 0) as Attr1,
       coalesce(Attr2, 0) as Attr2,
       etc