/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

9 votes271 views1 answer
Identity insert on sql server
SQL
0 vote262 views1 answer
Postgres add prefix to primary key
SQL
1 vote285 views2 answers
Mysql error 1215
SQL
20 votes327 views4 answers
How to find average in sql
SQL
0 vote280 views1 answer
Sql server remove 0 from left
SQL
0 vote315 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote312 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote264 views1 answer
Oracle list dblink
SQL
0 vote264 views1 answer
Postgres float to int
SQL
4 votes283 views1 answer
What are the data types in sql
SQL

Share