/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 vote131 views2 answers
Mysql get day of week
SQL
2 votes120 views1 answer
Alter table add column and foreign key mysql
SQL
24 votes121 views4 answers
Postgres delete database
SQL
0 vote122 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote168 views1 answer
Sqlite display headers on columns
SQL
1 vote121 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote112 views1 answer
Psql datestyle
SQL
0 vote127 views1 answer
One table with another
SQL
16 votes125 views3 answers
T-SQL Add Column
SQL
-1 vote70 views3 answers
Ubuntu install mssql
SQL