/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 vote137 views1 answer
Mysql drop multiple tables at once
SQL
0 vote135 views1 answer
Mysql timediff
SQL
0 vote133 views1 answer
What is the use of index in mysql table
SQL
14 votes141 views1 answer
Oracle new column
SQL
11 votes140 views2 answers
Having in sql
SQL
1 vote168 views1 answer
Epoch time converter in snowflake
SQL
1 vote134 views2 answers
Find a column in all tables mysql
SQL
1 vote183 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote112 views0 answer
SQL
0 vote152 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL

Share