/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

6 votes122 views1 answer
Rank function in oracle with example
SQL
0 vote117 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote140 views1 answer
Sql put two columns into one
SQL
2 votes177 views1 answer
Remove foreign key constraints in postgres
SQL
1 vote124 views1 answer
PLS-00225 type
SQL
18 votes133 views6 answers
Creating table in MySQL
SQL
1 vote134 views2 answers
Pad zero sql server
SQL
6 votes165 views1 answer
Check Table Exists
SQL
25 votes147 views4 answers
Import mysql dump command line
SQL
14 votes136 views2 answers
Sql cast
SQL