/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 vote179 views1 answer
UseSqlServer no definition
SQL
0 vote151 views1 answer
How to order result of subquery in select
SQL
0 vote188 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
11 votes165 views1 answer
How to get ddl for materialized view
SQL
0 vote158 views1 answer
Exit psql
SQL
0 vote188 views1 answer
Postgresql concat string with separator
SQL
0 vote179 views1 answer
SQL Where-Klausel
SQL
1 vote157 views2 answers
Replace text in sql
SQL
0 vote179 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote160 views1 answer
If column value is null then in mysql
SQL

Share