/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

12 votes215 views5 answers
Sql primary key
SQL
2 votes211 views1 answer
Postgresql drop primary key constraint
SQL
0 vote242 views1 answer
Test sql query
SQL
0 vote197 views1 answer
Nth max in my sql
SQL
14 votes219 views1 answer
Oracle new column
SQL
18 votes193 views3 answers
Mysql add column with default value
SQL
2 votes204 views2 answers
Useradd postgres
SQL
0 vote172 views1 answer
Sqlalchemy existing database
SQL
0 vote236 views1 answer
Sparql if bound query
SQL
1 vote207 views1 answer
Sql try catch
SQL