/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

1 vote186 views1 answer
Postgres grant read only access to database
SQL
1 vote191 views1 answer
Oracle apex prevent initial load
SQL
0 vote195 views1 answer
Multiple left join mysql
SQL
0 vote191 views1 answer
Select other columns with distinct
SQL
2 votes218 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote190 views1 answer
Flask sqlalchemy decimal
SQL
1 vote212 views1 answer
Mysql order by desc null last
SQL
8 votes175 views2 answers
Phpmyadmin password
SQL
0 vote182 views1 answer
Sql date between one week
SQL
0 vote416 views1 answer
Sql datum formatieren
SQL

Share