Answers for "postgresql copy table structure"

SQL
1

copy table postgres

CREATE TABLE new_table AS 
TABLE existing_table;
Posted by: Guest on April-08-2020
0

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 )
Posted by: Guest on July-19-2020

Code answers related to "postgresql copy table structure"

Code answers related to "SQL"

Browse Popular Code Answers by Language