/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 vote192 views1 answer
Criteria builder select subset of column
SQL
1 vote208 views1 answer
Postgres install unaccent extension
SQL
0 vote219 views1 answer
Drop-toys-table
SQL
7 votes208 views1 answer
Mysql remote connection command line
SQL
1 vote208 views3 answers
Execute sp in sql server
SQL
0 vote202 views1 answer
Mariadb errno 121
SQL
0 vote197 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote199 views1 answer
Oracle explain plan
SQL
1 vote228 views1 answer
Default
SQL
0 vote226 views1 answer
In query in sql
SQL

Share