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

0 vote217 views1 answer
Sql insert from excel
SQL
5 votes183 views2 answers
Update all rows mysql
SQL
0 vote241 views1 answer
Tsql find procedure with name
SQL
2 votes178 views1 answer
Mysql how to store lat,lng
SQL
12 votes192 views2 answers
Delete all entries postgres
SQL
11 votes215 views1 answer
Ddl view
SQL
0 vote173 views1 answer
Resulting Query
SQL
0 vote198 views2 answers
Port 5432 is already in use mac
SQL
0 vote213 views1 answer
Convert int to varchar sql
SQL
2 votes183 views3 answers
Mysql pass command from command line
SQL