How to copy certain tables from one schema to another within same DB in Postgres keeping the original schema?

Question

I want to copy only 4 tables from schema1 to schema2 within same DB in Postgres. And would like to keep the tables in schema1 as well. Any idea how to do that in pgadmin as well as from postgres console ?

Answer 1

You can use create table ... like

create table schema2.the_table (like schema1.the_table including all); 

Then insert the data from the source to the destination:

insert into schema2.the_table select *  from schema1.the_table; 

Answer 2

You can use CREATE TABLE AS SELECT. This ways you do not need to insert. Table will be created with data.

CREATE TABLE schema2.the_table AS  SELECT * FROM schema1.the_table;