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 vote269 views1 answer
How to retrive the today date sql
SQL
0 vote255 views1 answer
Uncomment listen_address=localhost
SQL
0 vote269 views1 answer
Mysql beautifier terminla
SQL
0 vote254 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote260 views1 answer
Dnsmasq.conf location macos
SQL
1 vote276 views1 answer
Sql drop schema
SQL
0 vote276 views1 answer
Convert LDAP Epoch to Date
SQL
1 vote266 views1 answer
How to unlock table in mysql
SQL
2 votes248 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
1 vote262 views1 answer
Mysql show long running queries
SQL