All that matters in Software Engg.
Get information on web/mobile app development with rails and other software engineering utilities.
Thursday, 4 July 2013
Postgres - SQL to get rows count for all tables
SELECT relname, n_tup_ins - n_tup_del as rowcount FROM pg_stat_all_tables where (n_tup_ins - n_tup_del) > 0 AND relname NOT LIKE 'pg_%';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment