/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

16 votes201 views2 answers
Sql vs nosql
SQL
7 votes301 views2 answers
Drop index oracle
SQL
0 vote180 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote185 views1 answer
Postpresql relation not found
SQL
0 vote212 views1 answer
Sql today at midnight
SQL
0 vote214 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
2 votes193 views1 answer
Oracle find unusable indexes
SQL
0 vote199 views1 answer
Mysql utc timestamp
SQL
0 vote172 views1 answer
Change default schema sql server
SQL
50 votes292 views6 answers
Sql count duplicate rows
SQL