database row count

From: Isaac Vetter <ivetter(at)math(dot)purdue(dot)edu>
To: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: database row count
Date: 2008-01-30 20:10:50
Message-ID: 47A0D9CA.4040306@math.purdue.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear Pg experts;

I'd like to get a (rough) count of the numbers of rows across all tables
in a given database.

I understand that I could write a script to run count(*) on each table
and then sum the counts. Is there an easier way, has someone already
written this script?

Much Thanks,

Isaac Vetter

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Carol Cheung 2008-01-30 21:14:29 Re: database row count
Previous Message Mija Lee 2008-01-30 18:02:59 Re: pg_cancel_backend and pg_ctl kill