/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 vote270 views1 answer
Can you write relational algebra into sql queries
SQL
4 votes283 views2 answers
Float postgres
SQL
1 vote246 views1 answer
Oracle current sequence value
SQL
0 vote254 views1 answer
Get server date mysql
SQL
1 vote270 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
9 votes292 views3 answers
Pyodbc connect to sql server
SQL
0 vote294 views1 answer
What is delimiter in mysql
SQL
5 votes275 views2 answers
Sql server port number
SQL
0 vote277 views1 answer
Sparql if bound query
SQL
0 vote279 views1 answer
Postgres row expiration
SQL

Share