Try renaming the schema. alter schema schemaname rename to newname;
then if you want the old schema back create a new one.
If there are already stuff in the schema you want to move to then
write a quick function using a for loop with the pg_class table
to write the alter table statement for anythi
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
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 mo
