On Wed, 21 Feb 2007 21:58:33 -0000
"Greg Sabino Mullane" <greg@turnstep.com> wrote:
> SELECT 'vacuum verbose analyze '||quote_ident(nspname)||'.'||quote_ident(relname)||';'
> FROM pg_class c, pg_namespace n
> WHERE relkind = 'r'
> AND relnamespace = n.oid
> AND nspname = 'novac'
> ORDER BY 1;
I assume you meant "AND nspname != 'novac'"
--
D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.