/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 vote131 views1 answer
How to get data between a last week in mysql
SQL
1 vote146 views1 answer
Error code 1292 mysql workbench
SQL
0 vote98 views1 answer
Now() -1 mysql
SQL
16 votes151 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote187 views1 answer
Cahnge column name apex oracle
SQL
15 votes143 views4 answers
Create table if not exists sql
SQL
0 vote143 views1 answer
Prodection ready postgres database step by step
SQL
2 votes150 views2 answers
Mysql on duplicate key update get value from values
SQL
2 votes177 views2 answers
Mysql search for column name in all tables
SQL
1 vote215 views1 answer
How to select the nth row in a SQL database table?
SQL

Share