/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

4 votes204 views5 answers
Get last query in codeigniter 4
SQL
22 votes172 views6 answers
Create sql table
SQL
7 votes165 views4 answers
Lowest salary in sql
SQL
1 vote156 views1 answer
Copy postgres table from one schema into another
SQL
0 vote180 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
3 votes212 views2 answers
Wp do sql query from function
SQL
2 votes173 views1 answer
How to get weekday from old date in sql
SQL
13 votes216 views6 answers
Mysql remove duplicates
SQL
0 vote169 views1 answer
Flask sqlalchemy decimal
SQL
3 votes145 views1 answer
Oracle failed login attempts
SQL