/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 vote386 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote370 views2 answers
How to add CHECK constraint to a column in postgres
SQL
-1 vote380 views1 answer
Mysql faster insert
SQL
0 vote384 views1 answer
Select top values sql
SQL
0 vote427 views1 answer
Select * from mysql.proc
SQL
0 vote338 views3 answers
Convert sql query to python pandas
SQL
2 votes378 views2 answers
Postgresql search all tables for column name
SQL
3 votes352 views2 answers
How to modify rows in SQL Server
SQL
-1 vote379 views1 answer
Sql select data from one database and insert into a different database
SQL
12 votes364 views6 answers
Select distinct
SQL

Share