clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 994903 fiddles created (11012 in the last week).

create table t (Col1 text, Col2 text, Col3 text, Col4 text); insert into t values (null, 'xyz', 'pdq', null), ('abc', 'def', 'ghj', null), ('hsh', 'fff', 'oko',null);
3 rows affected
 hidden batch(es)


do $$ declare cols text; begin cols := string_agg('count(' || column_name::text || ') ' || column_name::text, ',') from (select column_name from information_schema.columns where table_name = 't') c; execute format('create temp table counter as select %s from t;', cols); end; $$; select * from counter;
col1 col2 col3 col4
2 3 3 0
 hidden batch(es)