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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to