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

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 (view raw or flat)
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

pgsql-hackers by date

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

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