Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group