Re: PL/PgSQL for counting all rows in all tables.

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PL/PgSQL for counting all rows in all tables.
Date: 2004-09-29 01:38:15
Message-ID: da437c9a6579f2426b3324b485c193ab@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


My version:

ANALYZE;

SELECT n.nspname, relname, reltuples
FROM pg_class c, pg_namespace n
WHERE c.relnamespace=n.oid
AND relkind='r'
AND NOT n.nspname ~ '^pg_'
ORDER BY 1,2;


- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200409282138

-----BEGIN PGP SIGNATURE-----

iD8DBQFBWhIivJuQZxSWSsgRAm3cAJwLySzR5mpOHDT06LN6vj9M5zyyOQCgt4j1
gWDPcXJoUZbTlZvxxrE7fcY=
=MOMs
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Mallete 2004-09-29 07:10:57 error: unicode characters greater than or equal to 0x10000
Previous Message David Fetter 2004-09-29 00:00:49 PL/PgSQL for counting all rows in all tables.