/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 vote201 views1 answer
Laravel migration sql dump
SQL
0 vote199 views1 answer
Oracle last connexion
SQL
1 vote208 views1 answer
Isnull sql server
SQL
1 vote201 views1 answer
Sql where max date
SQL
0 vote201 views1 answer
Exclude last comma separated string mysql
SQL
0 vote198 views2 answers
Transaction php
SQL
0 vote164 views1 answer
CREATE MULTIPLE FK
SQL
0 vote189 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote187 views1 answer
Sql select duplicates based on two columns
SQL
0 vote237 views1 answer
Kimball data warehouse sql calendar
SQL