/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 vote362 views1 answer
PostgreSQL types and C# types
SQL
0 vote319 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote275 views8 answers
Convert sql query to linq online
SQL
0 vote330 views1 answer
Sql show table name in result
SQL
0 vote331 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote344 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
-1 vote338 views2 answers
Postgres autoincrement primary key
SQL
1 vote253 views1 answer
Ms sql - add one hour to time
SQL
0 vote314 views1 answer
Running query in redshift
SQL
2 votes341 views2 answers
Create empty table from existing table
SQL

Share