/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 vote186 views1 answer
How to see the query of a view in mysql
SQL
0 vote166 views1 answer
Split string by comma in sql server
SQL
0 vote187 views1 answer
How to check default value of column in sql server
SQL
0 vote180 views2 answers
Port 5432 is already in use mac
SQL
0 vote189 views1 answer
Sql create and grant user access to database
SQL
1 vote159 views1 answer
Declare table variable
SQL
6 votes205 views1 answer
How to get the size of the database in postgresql
SQL
0 vote196 views1 answer
Get initial in sql
SQL
2 votes167 views1 answer
How to insert string variable into sqlite database
SQL
0 vote166 views1 answer
Doesn't have default value mysql
SQL

Share