count columns psql(PostreSQL)

The solution for this is noted below

count columns psql(PostreSQL)

Solution

select table_name, count(*) as column_count
from information_schema."columns"
where table_schema = 'public' 
GROUP by table_name order by column_count desc;

Try other methods by searching on the site. That is if this doesn’t work