/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

18 votes273 views6 answers
Creating table in MySQL
SQL
36 votes270 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote264 views1 answer
With_for_update sqlalchemy
SQL
0 vote278 views1 answer
Change filed order in mysql
SQL
2 votes266 views1 answer
Get first 2 letter in sql
SQL
0 vote291 views2 answers
Identity syntax in sql
SQL
1 vote259 views1 answer
Postgres delete from where date is greater than specific date
SQL
4 votes255 views1 answer
Wilayah indonesia sql
SQL
14 votes280 views2 answers
Install mysqldump
SQL
-1 vote290 views2 answers
Import data from excel to sql server automatically
SQL