/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

0 vote279 views1 answer
Top frequency in sql server
SQL
0 vote261 views1 answer
Json_remove mysql
SQL
-1 vote223 views2 answers
Datetime sql server week
SQL
0 vote276 views1 answer
Pgsql is not permitted to log in
SQL
1 vote282 views1 answer
Mysql event last execution
SQL
10 votes285 views4 answers
Primary key in sql
SQL
0 vote264 views1 answer
Codeigniter dbforge add index
SQL
0 vote267 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote272 views1 answer
Mysql month name extract
SQL
6 votes273 views4 answers
Delete table sqlite
SQL

Share