/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

7 votes186 views2 answers
Html to react converter
SQL
1 vote183 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote214 views1 answer
How to find symmetric pairs in sql
SQL
0 vote257 views1 answer
Sqlite schema structure of a relational database
SQL
1 vote277 views1 answer
Column with prefix in sql
SQL
1 vote203 views5 answers
Sql 2nd highest salary
SQL
10 votes240 views4 answers
Else if mysql
SQL
0 vote177 views1 answer
Check psql validity function
SQL
0 vote342 views1 answer
How to use select union and loop
SQL
0 vote199 views1 answer
Mysql select inside sum
SQL