>
> In order to maintain the database schema, I started out by using
> a script like this one which I kept stored in my source
> repository:
>
I do something similar: keep the source code for the database
schema in the cvs repository with my application code...
But I do not use a shell script!
I just write sql and "run" it in psql using
\i schemaText