/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 vote156 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote241 views1 answer
Install ms sql server management studio
SQL
8 votes164 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote175 views2 answers
Sql stored procedure for access frontend
SQL
1 vote148 views1 answer
Group_concat max length mysql
SQL
1 vote150 views1 answer
Oracle select first result
SQL
0 vote146 views1 answer
Power query case when
SQL
6 votes165 views3 answers
Sql select last id
SQL
0 vote180 views1 answer
How to combine rows in sql server procedure
SQL
0 vote362 views1 answer
Redirection 301 htaccess nom de domaine
SQL