/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 vote126 views1 answer
Select from another database
SQL
17 votes150 views6 answers
Get last record in sql
SQL
4 votes156 views3 answers
Postgres drop all tables
SQL
0 vote146 views1 answer
Str_to_date sql server
SQL
2 votes159 views1 answer
Sql server: select column values as comma separated string
SQL
16 votes121 views1 answer
Sqlserver add column to table
SQL
-1 vote135 views1 answer
How to dump .csv file into mysql
SQL
51 votes232 views6 answers
Opera gx
SQL
-1 vote127 views5 answers
Online sql to linq generator
SQL
0 vote150 views1 answer
How to combine rows in sql server procedure
SQL