/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 vote349 views1 answer
Oracle show execution plan
SQL
13 votes308 views6 answers
Mysql update from select
SQL
0 vote296 views1 answer
Docker export psql sql
SQL
2 votes307 views4 answers
Duplicate record mysql
SQL
0 vote321 views1 answer
Postrgres trunc
SQL
0 vote332 views1 answer
Sql select column name like from multiple tables
SQL
0 vote311 views1 answer
Mysql enter ubuntu
SQL
0 vote304 views1 answer
Postgres enumerated type
SQL
0 vote344 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote303 views1 answer
Sql select rows with different values in one column
SQL

Share