Count column of tables psql

1
2
3
4
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

5 votes178 views2 answers
Ranking functions in sql
SQL
0 vote179 views1 answer
Laravel migration sql dump
SQL
0 vote170 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote175 views1 answer
Narural join
SQL
3 votes203 views1 answer
RENAME table pl sql
SQL
0 vote155 views2 answers
Mysql regexp match word
SQL
0 vote167 views1 answer
Python sql last insertend
SQL
0 vote126 views1 answer
Big query add table rows to another table
SQL
0 vote180 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote185 views1 answer
Turn on foreign keys check mysql
SQL