/SQL/Copy table postgres

Copy table postgres

Copy table postgres

CREATE TABLE new_table AS 
SELECT
*
FROM
    existing_table
WHERE
    condition;

2

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;

1

Source: stackoverflow.com

Copy table postgres

CREATE TABLE new_table AS 
TABLE existing_table;

1

Source: postgresqltutorial.com

Similar codes

4 votes322 views3 answers
Postgres drop all tables
SQL
0 vote295 views1 answer
Consulta alias con inner join
SQL
0 vote258 views1 answer
Strat with in sql
SQL
1 vote271 views1 answer
How much every mysql database record takes from diskspace
SQL
3 votes291 views1 answer
Laravel database Using Named Bindings
SQL
0 vote267 views1 answer
Nueva tabla mysql
SQL
13 votes275 views2 answers
Sql join
SQL
2 votes299 views5 answers
Install postgresql 10 centos 7
SQL
-2 votes268 views3 answers
Sqlite reset autoincrement
SQL
0 vote303 views1 answer
Mysql date without time
SQL

Share