/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 vote366 views1 answer
Create table like sql
SQL
5 votes339 views1 answer
JBDC
SQL
0 vote345 views1 answer
Sql get highest date from 3 tabels
SQL
4 votes323 views2 answers
Error loading MySQLdb module.
SQL
13 votes320 views2 answers
Display users in mysql
SQL
6 votes362 views2 answers
Difference between join vs union
SQL
16 votes336 views2 answers
Oracle ddl
SQL
6 votes373 views2 answers
Mysql convert timestamp to date
SQL
1 vote331 views1 answer
Add constraint sql
SQL
0 vote371 views1 answer
Time data type in mysql
SQL

Share