copy data fromone table to other in psql code example
Example: postgres copy table from one schema to another
create table schema2.the_table (like schema1.the_table including all);
insert into schema2.the_table
select *
from schema1.the_table;
create table schema2.the_table (like schema1.the_table including all);
insert into schema2.the_table
select *
from schema1.the_table;