/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

3 votes269 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote274 views3 answers
Mysql Server Start
SQL
0 vote296 views1 answer
What is initial catalog in sql connection string
SQL
1 vote298 views1 answer
Oracle nvl2
SQL
14 votes285 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
1 vote288 views1 answer
Pgsql sum switch case
SQL
0 vote288 views1 answer
Get date from timestamp in mysql
SQL
0 vote273 views1 answer
Sql server count all tables rows
SQL
8 votes293 views1 answer
Oracle add datafile to tablespace
SQL
0 vote274 views1 answer
Mysql set boolean default value
SQL