/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 vote150 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote133 views1 answer
Vowels in sql
SQL
0 vote152 views1 answer
Rails sql query converstion
SQL
0 vote93 views1 answer
Check sql query executed wp
SQL
1 vote143 views1 answer
Oracle grant on all tables in schema
SQL
5 votes305 views2 answers
How to ascending order in sql
SQL
22 votes144 views6 answers
Create sql table
SQL
4 votes134 views1 answer
Oracle error line
SQL
1 vote150 views1 answer
Full sql mode
SQL
1 vote133 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL