/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 vote214 views1 answer
Create view in mysql workbench
SQL
1 vote180 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote197 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote187 views1 answer
2020 new year
SQL
0 vote195 views2 answers
Oracle create tablespace autoextend
SQL
2 votes201 views2 answers
Mysql find max value row
SQL
0 vote204 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote195 views2 answers
Mysql on update current_timestamp
SQL
1 vote186 views2 answers
Rebuild index sql server
SQL
0 vote205 views1 answer
Placements hackerrank solution
SQL

Share