/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 vote135 views1 answer
Create schema sql server
SQL
0 vote144 views1 answer
Create table in dbms cmds
SQL
0 vote132 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote142 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote157 views1 answer
Php select data from mysql database without column name
SQL
2 votes146 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
3 votes173 views1 answer
Oracle apex warn on unsaved changes
SQL
2 votes137 views2 answers
Sql first character
SQL
0 vote139 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote129 views1 answer
Partitioning in oracle-base
SQL