/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
Hibernate dialect property xml for mysql 8
SQL
4 votes123 views1 answer
Mysql biginteger size
SQL
0 vote121 views1 answer
Postgresql alter column nullable
SQL
3 votes117 views4 answers
Stop MySQL
SQL
0 vote126 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
10 votes119 views3 answers
Sql check double value
SQL
0 vote112 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote126 views1 answer
Install postgresql 12 on debian 10
SQL
1 vote79 views1 answer
Into sql
SQL
3 votes107 views1 answer
What is having clause
SQL