/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

2 votes356 views1 answer
Oracle sql concatenate results into string
SQL
5 votes368 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote376 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote330 views1 answer
Drop check command
SQL
0 vote360 views1 answer
Ms sql database data size
SQL
0 vote368 views1 answer
Sql character index
SQL
0 vote417 views1 answer
Find and replace query in wordpress\
SQL
0 vote356 views1 answer
How to execute stored output to csv files
SQL
0 vote363 views1 answer
Python connect microsoft sql server
SQL
0 vote435 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL

Share