Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2010/3/13 Manlio Perillo <manlio.perillo@gmail.com>:
>> Usually when I need to restore a database to its initial state, what I
>> do is to simply drop it, and then re-create it.
>> However on a shared hosting this is not possible.
> Usually people use a install and a uninstall scripts. First creates
> dbobjects, second removes objects.
"pg_dump --clean" can help with creating an uninstall script.
regards, tom lane