/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 vote110 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
1 vote114 views4 answers
Psql check tables command
SQL
0 vote117 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote134 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
1 vote113 views1 answer
Python clean sql string
SQL
0 vote122 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote132 views1 answer
What is delimiter in mysql
SQL
1 vote118 views1 answer
Mysql get character set
SQL
2 votes103 views3 answers
How to get second highest salary in each department in sql
SQL
-1 vote130 views3 answers
How to restart mysql in linux
SQL

Share