/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

0 vote430 views1 answer
How to check common records in 2 table
SQL
49 votes398 views6 answers
Alter table add column
SQL
0 vote355 views1 answer
Flask sqlalchemy remove duplicates
SQL
1 vote327 views2 answers
Sql where is not number
SQL
4 votes349 views1 answer
Describe table mysql
SQL
0 vote366 views1 answer
Oracle sql add column auto generated value
SQL
0 vote343 views1 answer
Increase speed of like queries postgres
SQL
2 votes375 views2 answers
How to add not null constraint in sql
SQL
1 vote340 views1 answer
Oracle user last connected
SQL
1 vote377 views1 answer
Table valued functions in sql
SQL