Postgres Pro
Downloads
Home   >   mailing lists

How do you find the row count for all your tables in Postgres? - Mailing list pgsql-general

From Nithya Soman
Subject How do you find the row count for all your tables in Postgres?
Date
Msg-id CAJG8ayAdqZEQ9XVnrKr6UpfV71hrN-ZEEje4AD=E6genzCKC9A@mail.gmail.com
Whole thread Raw
Responses Re: How do you find the row count for all your tables in Postgres?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
Hi

How can we find the total row count for all db tables in psql version  7.4.3 ??

The query which worked fine in psql 9.2 version is :
SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC.

But same query throws error as 'ERROR:  column "n_live_tup" does not exist' in psql 7.4.30. Could you please provide a valid query to get row count for all db tables in psql  7.4.3 ?


pgsql-general by date:

Previous
From: Ilya Ivanov
Date:
Subject: Re: Regexp matching + typecasts
Next
From: Adrian Klaver
Date:
Subject: Re: Postgres 9.2.8 crash sporadically on Windows