/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 views2 answers
Postgres default user
SQL
-2 votes164 views1 answer
Create trigger syntax
SQL
0 vote177 views1 answer
Mysql type for large numbers with many decimal
SQL
1 vote167 views1 answer
Sql week commencing date
SQL
0 vote184 views1 answer
Postgres clear table
SQL
0 vote180 views1 answer
Null column as zero in mysql
SQL
1 vote171 views1 answer
Return size of tables in mysql
SQL
0 vote197 views1 answer
"Hello User Name"
SQL
1 vote171 views1 answer
Oracle user last connection date
SQL
2 votes243 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL