Answers for "create a new table from existing table sql postgres"

SQL
1

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

Code answers related to "create a new table from existing table sql postgres"

Code answers related to "SQL"

Browse Popular Code Answers by Language