ALTER TABLE name
SET SCHEMA new_schema
Naz Gassiep wrote:
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 majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
