/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 vote286 views1 answer
Show all mongodb
SQL
3 votes204 views1 answer
Oracle APEX elapsed time
SQL
4 votes210 views1 answer
Mysql not equal
SQL
0 vote197 views1 answer
Mysql change default collation
SQL
5 votes319 views1 answer
Oracle asynchronous procedure
SQL
0 vote226 views1 answer
Sql statement show all emails with dome
SQL
0 vote230 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote202 views1 answer
How to move a columns location in mysql
SQL
4 votes197 views2 answers
Sql table
SQL
0 vote208 views1 answer
SQL: calculate hours from two dates
SQL

Share