/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 vote147 views1 answer
Yesql
SQL
1 vote149 views1 answer
Convert varchar to int in sqlite
SQL
0 vote146 views1 answer
Get role postgres
SQL
0 vote189 views1 answer
Example database query
SQL
0 vote134 views1 answer
Postgresql newline character
SQL
8 votes136 views1 answer
Unique vs primary key
SQL
-1 vote129 views3 answers
Mysql get age from date
SQL
1 vote137 views1 answer
Postgres check for foreign key
SQL
14 votes146 views5 answers
Set password for postgres user ubuntu
SQL
0 vote147 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL

Share