Count columns psql(PostreSQL)

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

Source: shekhargulati.com

Similar codes

0 vote199 views4 answers
How to get max salary in each department in sql
SQL
0 vote192 views1 answer
Flexible search query delete table
SQL
0 vote153 views1 answer
Sqlalchemy existing database
SQL
7 votes190 views2 answers
Get database size mysql
SQL
0 vote178 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote142 views1 answer
Plsql trigger insert update
SQL
3 votes226 views1 answer
Mysql cli connect with password
SQL
0 vote194 views2 answers
Identity column in sql server
SQL
0 vote180 views1 answer
Show database not empty tables postgres
SQL
1 vote187 views1 answer
Mysql alter decimal precision
SQL