/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 vote200 views1 answer
Connect by query in oracle
SQL
0 vote192 views1 answer
Add plugins to mysql workbench
SQL
0 vote256 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote188 views1 answer
Create new schema mysql
SQL
3 votes188 views1 answer
Oracle wait
SQL
10 votes193 views4 answers
Sql pagination
SQL
10 votes174 views2 answers
Sql merge statement
SQL
0 vote229 views1 answer
Select count postgres double row count > 1
SQL
0 vote205 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
11 votes296 views5 answers
Update table from another table mysql
SQL