/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 vote198 views1 answer
How to join result table in mysql
SQL
5 votes188 views3 answers
Mysql extract month from date
SQL
10 votes154 views2 answers
Sql where clause multiple values
SQL
3 votes254 views2 answers
How to modify rows in SQL Server
SQL
1 vote184 views2 answers
Grab part of a string sql
SQL
1 vote198 views1 answer
Snowflake rename column name
SQL
0 vote256 views1 answer
Doctors appointment
SQL
1 vote183 views1 answer
Temp table vs variable table in sql server
SQL
0 vote190 views1 answer
Move table to a different schema
SQL
0 vote233 views1 answer
SQL SERVER Add Identity Column to existing table
SQL

Share