How to copy certain tables from one schema to another within same DB in Postgres keeping the original schema?
<p>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 ?</p>