/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

4 votes265 views1 answer
For loop postgresql
SQL
3 votes251 views1 answer
Oracle revoke
SQL
0 vote275 views1 answer
Offset in postgresql example
SQL
10 votes211 views1 answer
Oracle view dependencies
SQL
1 vote253 views1 answer
Mysql return text after a final full stop
SQL
0 vote234 views1 answer
Mysql events not work
SQL
22 votes258 views4 answers
Mysql reset auto increment id
SQL
0 vote251 views1 answer
Safe mysql
SQL
0 vote262 views1 answer
Edit a field mysql terminal
SQL
0 vote257 views1 answer
Sql remove decimal places
SQL