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

2 votes271 views4 answers
Mysql select into new table
SQL
0 vote277 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
2 votes286 views1 answer
Mariadb json select
SQL
0 vote275 views1 answer
Less than and between in sql query
SQL
0 vote266 views1 answer
Mysql terminal list table
SQL
0 vote256 views1 answer
SQL Server format datetime
SQL
0 vote290 views1 answer
Oracle show grants on table
SQL
0 vote280 views2 answers
What is the default password for sql server sa
SQL
1 vote253 views1 answer
Firebase bigquery cloud message
SQL
2 votes274 views1 answer
Change primary key sql
SQL