copy structure of table postgresql code example
Example 1: copy table postgres
CREATE TABLE new_table AS
TABLE existing_table;
Example 2: copy column from one table to another without column duplicate postgres
//Postgres Database Query
insert into table1(column1,column2)
select c1,c2
from table2 a
where not exists ( select 0 from table1 b where b.id = a.id )