/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

7 votes118 views2 answers
Oracle foreign key reference table
SQL
0 vote139 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote106 views1 answer
Create schema sql server
SQL
0 vote230 views1 answer
Sql change a colum to unique
SQL
0 vote99 views1 answer
Minus equivalent in my sql
SQL
1 vote110 views1 answer
Not exists mysql
SQL
0 vote128 views1 answer
Convert LDAP Epoch to Date
SQL
1 vote101 views1 answer
Set id count mysql
SQL
10 votes99 views4 answers
Primary key in sql
SQL
0 vote105 views1 answer
Sql put two columns into one
SQL