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

3 votes241 views3 answers
Stop mysql service ubuntu
SQL
0 vote274 views1 answer
Get initials name in sql
SQL
0 vote260 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote246 views1 answer
Tsql default value when no value returned by query
SQL
0 vote293 views1 answer
Gcloud sql list databases
SQL
2 votes280 views2 answers
Create temporary table in mysql
SQL
2 votes259 views1 answer
How to find constraints on a table in oracle
SQL
0 vote262 views4 answers
Mysql on kubernetes
SQL
1 vote247 views1 answer
How to select random rows from table
SQL
0 vote242 views1 answer
Oracle right characters
SQL