/SQL/Copy postgres table from one schema into another

Copy postgres table from one schema into another

Copy postgres table from one schema into another

create table schema2.the_table (like schema1.the_table including all);
insert into schema2.the_table
select * 
from schema1.the_table;

1

Source: stackoverflow.com

Similar codes

1 vote129 views1 answer
Postgresql contains
SQL
1 vote126 views2 answers
Mysql join two tables
SQL
0 vote137 views1 answer
How to create a table in sql stack overflow
SQL
0 vote117 views1 answer
Postgresql create user roles
SQL
0 vote147 views2 answers
How to list all values of a column that start with a letter in sql
SQL
2 votes109 views2 answers
Get all columns from table sql
SQL
0 vote155 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote137 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote137 views2 answers
How to type a blank discord messgae
SQL
0 vote123 views1 answer
How to reset table in sql server
SQL

Share