/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 vote322 views1 answer
Get server date mysql
SQL
2 votes329 views3 answers
Oracle show column of table
SQL
0 vote340 views1 answer
Mysql page segment
SQL
0 vote360 views1 answer
Oracle string length
SQL
0 vote322 views1 answer
Postgresql create user roles
SQL
2 votes325 views1 answer
Oracle convert run_duration to number
SQL
0 vote323 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote386 views1 answer
How to set up a trigger in sql
SQL
1 vote364 views1 answer
Alter constraint in sql
SQL
0 vote341 views1 answer
Postgresql delete type
SQL

Share