/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 vote346 views1 answer
Table user postgres
SQL
1 vote317 views1 answer
List index mysql cli
SQL
0 vote356 views1 answer
Carbon mysql d m y to y-m-d
SQL
2 votes390 views2 answers
MySql FULL OUTER JOIN
SQL
5 votes381 views1 answer
Mysql where one year ago
SQL
15 votes307 views2 answers
How to know the username of postgresql
SQL
3 votes346 views1 answer
Sql add two values together
SQL
1 vote342 views2 answers
Mysql switch case
SQL
0 vote334 views1 answer
Why we have to set the password for my sql server
SQL
0 vote328 views4 answers
Stored procedure sql
SQL

Share