/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 vote171 views1 answer
Check duplicate values plsql
SQL
1 vote178 views1 answer
T-sql find object by name
SQL
1 vote175 views1 answer
Sql server read uncommitted
SQL
2 votes186 views1 answer
How to find table table in stored procedure sql server
SQL
1 vote200 views1 answer
Default
SQL
1 vote166 views1 answer
Limit offset order by mysql
SQL
0 vote198 views1 answer
Sql missing values
SQL
0 vote176 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote189 views1 answer
Mariadb maximum left join
SQL
8 votes193 views2 answers
Grant all privileges database postgres to user
SQL