/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 vote281 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote278 views1 answer
Changer un mot de passe mysql
SQL
0 vote279 views1 answer
Pl sql search saurce code
SQL
0 vote306 views1 answer
Sql out file formate
SQL
9 votes292 views6 answers
Sql add column with default value
SQL
10 votes341 views6 answers
Mysql set root password
SQL
1 vote307 views2 answers
Postgres cast as decimal
SQL
1 vote284 views1 answer
Mysql connect command
SQL
5 votes301 views1 answer
How to get all dates in a month in oracle
SQL
0 vote302 views1 answer
Sqlcmd no headers
SQL

Share