/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 vote148 views1 answer
1 column values in to 1 single row in sql
SQL
31 votes152 views3 answers
Sql count(*)
SQL
0 vote145 views1 answer
Oarcale list objects
SQL
0 vote152 views1 answer
Dapper run sql script with parameters
SQL
3 votes152 views2 answers
Oracle apex charging debug
SQL
0 vote189 views1 answer
How to login to mysql in homestead
SQL
1 vote140 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote153 views1 answer
Sql get missing id
SQL
5 votes172 views4 answers
SQL Order of execution
SQL
1 vote164 views2 answers
Difference between in and between in sql
SQL