/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 vote117 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote107 views1 answer
Mysql text to decimal
SQL
6 votes155 views2 answers
Database url postgres
SQL
23 votes106 views4 answers
How to show all users in mysql
SQL
0 vote115 views1 answer
Mysql custom sort order
SQL
1 vote58 views1 answer
Mysql collation
SQL
26 votes110 views2 answers
Mysql workbench download
SQL
0 vote188 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote104 views2 answers
Mysql to python pandas
SQL
11 votes109 views2 answers
Safe mode off mysql
SQL