Answers for "count column of tables psql"

SQL
0

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;
Posted by: Guest on November-14-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language