/SQL/Postgres copy table from one schema to another

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;

Source: stackoverflow.com

Copy from one table to another postgres using matching column

UPDATE Table2 --format schema.table_name
SET 
ref_id2 = table1.ref_id1
FROM table1 -- mention schema name
WHERE table1.id = table2.id
AND 
table1.a_ref1 = table2.b_ref1;

Source: stackoverflow.com

Similar codes

1 vote268 views1 answer
Change table to innodb mysql
SQL
2 votes270 views3 answers
Current month mysql query
SQL
3 votes290 views1 answer
Sql add two values together
SQL
1 vote286 views1 answer
Mysql select and count left join
SQL
0 vote279 views2 answers
Oracle sql for each row
SQL
3 votes298 views2 answers
Mysql update row
SQL
0 vote272 views1 answer
First Step in installing SQL workbench
SQL
0 vote272 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote278 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote260 views1 answer
Postgresql remove duplicate rows 2 columns
SQL