On Wed, 21 Feb 2007 21:58:33 -0000 "Greg Sabino Mullane" <greg@xxxxxxxxxxxx> 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@xxxxxxxxx> | 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.
