/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 vote133 views1 answer
Mariadb errno 121
SQL
2 votes200 views2 answers
How to DROP a table in mysql
SQL
0 vote163 views2 answers
Suse Linux restart MySQL
SQL
0 vote131 views1 answer
Mysql workbench view
SQL
0 vote159 views1 answer
Mysql date without time
SQL
0 vote169 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote125 views1 answer
Openquery insert into linked server
SQL
0 vote134 views1 answer
Find all tables where column name exists oracle
SQL
3 votes137 views2 answers
Check data in table mysql
SQL
0 vote145 views1 answer
Sql output select
SQL

Share