Mark Dalphin writes:
>I am very pleased to see the program written and think it may be
>useful for others. I wonder if it might be written "more elegantly",
>somehow accessing the Postgresql meta-data directly, but that is by
>way of musing rather than critisism, for I don't know how to do it.
I think that would be abetter way to do it, yes. I already had a
shell script to vacuum all the databases individually and wrote a
quick perl script to generate the SQL commands, and I just glued the
two together because I needed it in a hurry.
>Shouldn't it be:
> if(/CREATE.+INDEX ...) ?
Good suggestion; I'll add that.
I'm open to more suggestions...I'll just keep adding stuff and see
where this goes.
Todd
