/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 vote141 views1 answer
Transaction database with php
SQL
0 vote147 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote164 views1 answer
Full outer join in mariadb mysql
SQL
0 vote173 views1 answer
Mysql date without time
SQL
0 vote151 views1 answer
Postgres can integer fields be negative
SQL
0 vote143 views1 answer
Doesn't have default value mysql
SQL
1 vote158 views1 answer
Mysql column start with string
SQL
18 votes146 views6 answers
Drop table if exists
SQL
0 vote144 views1 answer
Gcloud check sql
SQL
1 vote154 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL

Share