www.yannlaviolette.com
Pages
(Move to ...)
Home
▼
Pages
(Move to ...)
▼
Wednesday, June 29, 2011
PostreSQL -=- Find all row count for every tables
In order to find all row count for every tables in a database, you can type the following SELECT
SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC;
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment