/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 vote346 views1 answer
Oracle allow space to user
SQL
10 votes365 views2 answers
Mysql alter add foreign key
SQL
0 vote354 views1 answer
Date on SQL
SQL
5 votes365 views2 answers
Postgresql add not null constraint
SQL
3 votes445 views1 answer
Oracle nextval insert
SQL
0 vote353 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote334 views1 answer
Download mysql database to excel in android studio
SQL
0 vote352 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
1 vote330 views2 answers
Difference between in and between in sql
SQL
0 vote335 views1 answer
Write sql query to show the details start from digit
SQL

Share