Answers for "copy data from one table to another postgres"

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;

Posted by: Guest on June-15-2020

copy value from one column to another postgres

UPDATE table SET columnB = columnA;

Posted by: Guest on January-26-2021

copy table postgres

CREATE TABLE new_table AS 
SELECT
*
FROM
    existing_table
WHERE
    condition;

Posted by: Guest on November-23-2020

Code answers related to "copy data from one table to another postgres"