/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 vote314 views1 answer
Oracle last connexion
SQL
0 vote331 views3 answers
Sql parenthetical expression examples
SQL
0 vote289 views2 answers
Sql server select where date
SQL
0 vote359 views1 answer
Oracle calculate statistics on partition
SQL
0 vote329 views3 answers
How to assign custom id in mysql
SQL
-1 vote317 views2 answers
Installing mysql on centos 7
SQL
0 vote306 views1 answer
Sql out file formate
SQL
0 vote300 views1 answer
Oracle current timestamp
SQL
0 vote302 views1 answer
Create tables from xsd to sql server database c#
SQL
4 votes297 views1 answer
Sql any
SQL