On Fri, Apr 22, 2005 at 11:36:46AM -0500, FBaron@co.belcorp.biz 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/