Changing schemas

[Naz Gassiep <naz@xxxxxxxx>]

   Is there a way to change the schema that all objects are in? 
Essentially I want to move everything currently in the database into 
public rather than having the complex schemas that I have at the moment. 
They are unnecessary and the DB complexity is trivial, so using schema 
partitioning is more trouble than it is worth. Is there a way I can do 
this? I tried editing a dump, but that has proven to be a little 
difficult, as I am not a master of regex.

If I can do it from within the DB before I do the dump that'd be easier. 
Is there a way to do this from within the DB?

Thanks,
- Naz.