/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 vote180 views1 answer
Mysql create table columns with spaces
SQL
20 votes232 views4 answers
Sql count if
SQL
0 vote203 views1 answer
SqlFunction does not exist
SQL
0 vote324 views1 answer
Multiple row join
SQL
-1 vote204 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote216 views1 answer
Insert or update sql query
SQL
0 vote207 views1 answer
Sql contains vs like
SQL
4 votes199 views1 answer
Oracle change nls_date_format permanently
SQL
2 votes204 views2 answers
Change mysql password from command line
SQL
1 vote155 views1 answer
Flask-sqlalchemy filter_by contains
SQL