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 vote136 views1 answer
Ffeathers express mysql application users login
SQL
0 vote130 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote145 views2 answers
How to truncate all table in mysql workbench
SQL
12 votes139 views6 answers
Select distinct
SQL
0 vote132 views1 answer
Match end of string regex sql
SQL
0 vote143 views1 answer
Least spark sql
SQL
6 votes131 views1 answer
Sqlite foreign key
SQL
1 vote141 views1 answer
Import sql file mysql commadn line
SQL
0 vote132 views1 answer
Kill thread
SQL
0 vote132 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL