Re: Contrib: Reindex script.

Shaun Thomas wrote:

>Ok,
>
>As before, this script is basically a vacuumdb for indexes.  I call it
>reindexdb on my own system, and put it in the postgres binary directory
>simply because it's indispensable in my system.
>
>This should be the last one.
>
[snip....]

Hi Shaun,

Thanks for that script but....
your script doesn't deal with mixed case table names (reindexdb -a).

I modified it to my needs by altering the REINDEX command from

$PSQL $PSQLOPT $ECHOOPT -c "REINDEX TABLE $tab" -d $db
to:

$PSQL $PSQLOPT $ECHOOPT -c "REINDEX TABLE \"$tab\"" -d $db

Regards
Tina