Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> 2010/3/13 Manlio Perillo <manlio(dot)perillo(at)gmail(dot)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