/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 vote144 views2 answers
Collation in sql
SQL
0 vote126 views1 answer
Search db for table name
SQL
7 votes136 views3 answers
Sql set
SQL
0 vote133 views1 answer
Convert polygon to text in mysql
SQL
0 vote127 views1 answer
Sql doesn't contain
SQL
1 vote128 views1 answer
SQL: merging multiple row data in string
SQL
6 votes134 views2 answers
Insert into select mysql
SQL
2 votes125 views1 answer
Cast string to datetime mysql
SQL
0 vote138 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote119 views1 answer
Drush sql-dump
SQL

Share