/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 vote374 views3 answers
How to increase size of column in sql
SQL
1 vote351 views1 answer
Importance of comment in mysql
SQL
0 vote370 views3 answers
Duplicate row mysql
SQL
0 vote361 views1 answer
Add unique constraint sql server multiple columns
SQL
8 votes375 views1 answer
Today minus 15 days postgresql
SQL
0 vote370 views1 answer
Example database query
SQL
0 vote370 views1 answer
Like date sql server not working
SQL
2 votes357 views1 answer
Check isolation level in mysql
SQL
5 votes352 views1 answer
Mysql get last day of month
SQL
13 votes426 views3 answers
Mysqldump structure only
SQL