postgres list tables and row counts
SELECT schemaname,relname,n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;postgres list tables and row counts
SELECT schemaname,relname,n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;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;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
