Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

postgres list tables and row counts

SELECT schemaname,relname,n_live_tup
  FROM pg_stat_user_tables
  ORDER BY n_live_tup DESC;
 
PREVIOUS NEXT
Tagged: #postgres #list #tables #row #counts
ADD COMMENT
Topic
Name
9+3 =