--- Tapan Trivedi <ttrivedi@webifyservices.com> wrote:
> Thanks Nigel but too late :-((
>
> Did try something and got really messed up. I guess
> database recreation
> is the only alternative left. Actually wanted to do
> this in 2 hrs time -
> already am late by a day.
This need not take a long time (unless you have a
really huge amount of data). Just dump the schema
(table definitions etc.) and the data separately (man
pg_dump for details). Check that the dump files are
ok, then drop the database. Edit the schema dump to
force everything to lower case (easy with a small
script). Restore the database:
psql < schema.dump
psql < data.dump
and you are fixed.
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com