/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

11 votes236 views5 answers
Laravel db facade
SQL
0 vote214 views1 answer
How to use group_concat in sql server
SQL
18 votes221 views3 answers
Mysql number format
SQL
0 vote264 views1 answer
Pl sql join 3 tables
SQL
0 vote214 views2 answers
Sql 2 way of select unique
SQL
0 vote226 views1 answer
Sql date between one week
SQL
0 vote213 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote290 views1 answer
Delete ids between sql
SQL
0 vote207 views1 answer
Difference between cross apply and inner join
SQL
0 vote224 views1 answer
Sql clear table
SQL