On Wed, 21 Feb 2007 21:58:33 -0000 "Greg Sabino Mullane" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
