/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

1 vote368 views1 answer
Mysql connect bash
SQL
5 votes349 views1 answer
Get table columns from sql
SQL
0 vote385 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
1 vote330 views1 answer
PLS-00225 type
SQL
0 vote318 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
10 votes359 views6 answers
Sql between
SQL
0 vote325 views1 answer
Sql inserted
SQL
2 votes335 views1 answer
Oracle list grants on procedure
SQL
0 vote319 views1 answer
Changer un mot de passe mysql
SQL
2 votes358 views1 answer
Q operator in sql
SQL