/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 vote57 views0 answer
SQL
-1 vote144 views1 answer
Minus vs except in sql
SQL
1 vote98 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote100 views1 answer
Show table columns
SQL
2 votes99 views1 answer
Sql as
SQL
2 votes103 views1 answer
Mysql time ago difference
SQL
5 votes101 views4 answers
Describe table postgres
SQL
0 vote112 views1 answer
Select year from dual oracle
SQL
57 votes262 views6 answers
Mysql alter table add column
SQL
18 votes102 views2 answers
Sql inner join
SQL

Share