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

1 vote197 views1 answer
DATE_SUB postgres
SQL
0 vote189 views1 answer
Check sql database table lock
SQL
10 votes200 views1 answer
User_dependencies
SQL
0 vote190 views1 answer
Postgres add prefix to primary key
SQL
7 votes284 views1 answer
Oracle alter sequence restart start with
SQL
5 votes191 views5 answers
Sqlite install python
SQL
1 vote190 views1 answer
Sql not equal multiple columns
SQL
-1 vote318 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote190 views1 answer
Get first name and last name from full name string in SQL
SQL
27 votes332 views3 answers
Mysql delete row
SQL