/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 vote233 views1 answer
Mysql coonect sample code
SQL
3 votes227 views1 answer
Sql server check version
SQL
1 vote236 views1 answer
Alter table column size oracle
SQL
0 vote282 views1 answer
Insert into using contant values and source table columns with sql
SQL
6 votes234 views5 answers
Alter table oracle
SQL
0 vote254 views1 answer
Repeatable read trong sql server
SQL
15 votes360 views2 answers
Sql order by alphabetical
SQL
0 vote223 views1 answer
Oracle archivemode
SQL
0 vote218 views1 answer
Mysql regex exact match
SQL
1 vote217 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL

Share