/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

1 vote360 views1 answer
Insert pg result of select
SQL
0 vote250 views1 answer
<script>alert
SQL
0 vote327 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote310 views1 answer
Grepper sql workbench download
SQL
8 votes329 views3 answers
Connect python to mysql
SQL
0 vote284 views1 answer
Sql requete number pair
SQL
0 vote362 views2 answers
Fanyi
SQL
0 vote328 views1 answer
Mysql match in serialized data
SQL
14 votes332 views5 answers
Sql oracle limit
SQL
1 vote340 views1 answer
Second last highest id in sql
SQL