/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

19 votes302 views2 answers
Mysql add column after another
SQL
0 vote400 views1 answer
Sqlite display data in separated columns
SQL
0 vote356 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote310 views1 answer
How to change owner in postgres
SQL
1 vote291 views1 answer
Sql get missing id
SQL
0 vote303 views1 answer
Import sql dump into postgresql database
SQL
14 votes321 views2 answers
Oracle add column with default value
SQL
9 votes286 views4 answers
Mysql show table fields
SQL
24 votes310 views4 answers
Postgres remove database
SQL
3 votes357 views2 answers
Wp do sql query from function
SQL