On Fri, Apr 22, 2005 at 11:36:46AM -0500, FBaron@xxxxxxxxxxxxxx wrote: > > psql -d Clibelcorpco -c "REINDEX DATABASE Clibelcorpco FORCE" > ERROR: REINDEX DATABASE: Can be executed only on the currently open > database. If the database name isn't all lowercase then you'll have to quote it. psql -d Clibelcorpco -c 'REINDEX DATABASE "Clibelcorpco"' See "Identifiers and Key Words" in the "SQL Syntax" chapter of the documentation to learn more about quoted identifiers. See also the REINDEX documentation and make sure you understand what REINDEX DATABASE does and doesn't do. Also, FORCE appears to be obsolete as of 7.4. There's also the contrib/reindexdb utility, although I haven't used it so I don't know how well it works. -- Michael Fuhr http://www.fuhr.org/~mfuhr/
