/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 vote100 views1 answer
Limiting query result using where in sql
SQL
0 vote136 views1 answer
Sql quary stuf
SQL
0 vote106 views1 answer
Sql create table with references not primary key
SQL
2 votes131 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
11 votes116 views2 answers
Safe mode off mysql
SQL
3 votes107 views2 answers
Postgres inner join vs join
SQL
0 vote135 views1 answer
Insert into table with only identity column
SQL
6 votes105 views2 answers
Return columns from table sql
SQL
5 votes117 views1 answer
Get column name sql server
SQL
1 vote156 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL

Share