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 vote349 views1 answer
Snowflake rename column name
SQL
0 vote417 views1 answer
Parent and child link in mysql
SQL
2 votes390 views2 answers
Oracle create table if not exists
SQL
0 vote374 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
16 votes331 views1 answer
CTE statement sql server
SQL
0 vote347 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote329 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote342 views1 answer
How to get data between a last week in mysql
SQL
0 vote330 views2 answers
Mysql multiply
SQL
1 vote331 views1 answer
Oracle list constraints
SQL