How to move tables from one schema to another in PostgreSQL
ALTER TABLE <table_name> SET SCHEMA <schema_name>;
Example:
move table “test” to “sales” schema.
ALTER TABLE test SET SCHEMA sales;
ALTER TABLE <table_name> SET SCHEMA <schema_name>;
Example:
move table “test” to “sales” schema.
ALTER TABLE test SET SCHEMA sales;