/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

7 votes331 views3 answers
How ot change name of column mysql
SQL
0 vote333 views1 answer
Using distinct and count together in sql
SQL
0 vote772 views2 answers
Zsh: command not found: mysq
SQL
0 vote329 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote386 views1 answer
Sql query for login with email or username
SQL
0 vote554 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
4 votes322 views3 answers
Mysql modify foreign key
SQL
1 vote329 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote346 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
2 votes352 views3 answers
Sql function
SQL