/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 vote158 views1 answer
How many rows affected in sqllite
SQL
9 votes167 views3 answers
Where clause sql
SQL
0 vote157 views3 answers
Find below average salary in sql
SQL
7 votes176 views4 answers
Mysql delete older duplicates
SQL
1 vote158 views1 answer
Sql row having max
SQL
0 vote144 views1 answer
Coalesce for comma separated in sql server
SQL
10 votes144 views5 answers
Create table mysql query
SQL
1 vote173 views1 answer
Hangfire clear all jobs
SQL
-1 vote153 views1 answer
Io
SQL
0 vote145 views1 answer
Sql server 2012 create or alter procedure
SQL