apply function to every column without explicitly writing column names

[Awhan Patnaik]

I would like to figure out the number of nulls in each column of a table.
Is there a less verbose way so that I don't have to write all the column
names?

select count(x) for x in all_column_names from table foo; <-- fictional

instead of

select count(col1), count(col2).... from table foo;