/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

1 vote161 views1 answer
Mysql random limit 1
SQL
1 vote167 views1 answer
Drop function
SQL
0 vote178 views1 answer
Mysql order by where condition sub query
SQL
0 vote165 views1 answer
Raven ql select count
SQL
1 vote168 views1 answer
Mysql sort by date column
SQL
0 vote166 views4 answers
Best data type to represent money in mysql
SQL
0 vote179 views1 answer
Create schema sql server
SQL
1 vote162 views2 answers
Sql where keyword
SQL
-1 vote170 views1 answer
Mysql case when multiple conditions
SQL
5 votes164 views1 answer
Postgres integer to serial
SQL

Share