/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

9 votes121 views2 answers
Default number in sql
SQL
3 votes144 views2 answers
Oracle apex view logs
SQL
6 votes1.2K views1 answer
Sql select second max
SQL
6 votes136 views4 answers
Remove spaces sql server
SQL
1 vote118 views2 answers
Mysql type conversion
SQL
9 votes135 views2 answers
Convert data type in sql
SQL
0 vote126 views1 answer
Sql missing values
SQL
-1 vote128 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
1 vote315 views1 answer
Postgres upgrade to superuser
SQL
0 vote128 views1 answer
Postgres create extension if not exists
SQL

Share