/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

26 votes186 views10 answers
Insert in to table sql
SQL
20 votes253 views6 answers
Mysql reset auto increment
SQL
2 votes276 views1 answer
Capitalize 1st letter in sql server
SQL
3 votes375 views6 answers
Sql unique select
SQL
11 votes230 views2 answers
Docker create postgres db
SQL
12 votes248 views3 answers
Install sqlite driver ubuntu
SQL
0 vote228 views1 answer
Get cpu details sql
SQL
21 votes253 views3 answers
Sql server search column name in all tables
SQL
13 votes233 views2 answers
Oracle inner join
SQL
2 votes228 views1 answer
How to check grants on a package in oracle
SQL