/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

4 votes299 views2 answers
Convert utc to est sql
SQL
7 votes290 views2 answers
Sql empty table
SQL
0 vote214 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote212 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote269 views1 answer
Restart serial number for postgres
SQL
6 votes212 views2 answers
Postgresql pg_dump
SQL
0 vote190 views1 answer
Case when with count and combining similar values in sql
SQL
1 vote210 views1 answer
Mysql not supported auth mode
SQL
3 votes223 views2 answers
MySQL query to get column names
SQL
1 vote192 views1 answer
Table information in sql server
SQL