Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 30 Jan 2008 15:10:50 -0500
- Message-id: <47A0D9CA.4040306@math.purdue.edu> <text/plain>
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
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
- Follow-Ups:
- Re: database row count
- From: Carol Cheung
- Re: database row count
- Prev by Date: Re: pg_cancel_backend and pg_ctl kill
- Next by Date: Re: database row count
- Previous by thread: Update from other tables slow
- Next by thread: Re: database row count
- Indexes: