/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 vote171 views1 answer
Set default value now() date
SQL
1 vote176 views1 answer
Mysql pretty date format
SQL
0 vote181 views7 answers
10 random questions use python and SQL
SQL
3 votes172 views1 answer
Mssql remove column
SQL
5 votes166 views1 answer
Postgresql functions
SQL
1 vote203 views1 answer
Postgresql can you have null foreign key
SQL
2 votes234 views1 answer
How to check grants on a package in oracle
SQL
1 vote158 views1 answer
Jooq convert using gbk
SQL
2 votes184 views1 answer
How to find table table in stored procedure sql server
SQL
2 votes204 views2 answers
Python escape string for sql
SQL