/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 vote126 views3 answers
Sql union
SQL
0 vote114 views1 answer
SQL server select to get sum of hours
SQL
2 votes108 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
7 votes124 views1 answer
Set sequence value oracle
SQL
0 vote149 views1 answer
Migrations.RunSQL
SQL
0 vote127 views1 answer
How to get specific salary in sql
SQL
1 vote146 views3 answers
Postgresql crete view
SQL
0 vote116 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote77 views0 answer
SQL
0 vote133 views1 answer
Look at running processes redshift
SQL