/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

1 vote310 views2 answers
Sql split string by space
SQL
0 vote280 views1 answer
How to fix mysql stop unexpectedly
SQL
2 votes270 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
11 votes274 views2 answers
Import sql file laravel cmd
SQL
0 vote269 views1 answer
Mysql update sequence with order by
SQL
0 vote299 views2 answers
Drop tables from local table database postgres
SQL
0 vote298 views1 answer
Postgres populate table from another table
SQL
0 vote296 views1 answer
Alter check command
SQL
0 vote326 views1 answer
Sql query inline if
SQL
48 votes330 views3 answers
Psql create database
SQL