/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

1 vote209 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote229 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote231 views1 answer
Import Data in MySQL without using any other software
SQL
3 votes219 views2 answers
Enter mysql command line
SQL
0 vote222 views2 answers
Postgres show current role
SQL
52 votes352 views6 answers
Rename column sql
SQL
0 vote207 views1 answer
Oracle procedure chain step
SQL
0 vote215 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote244 views1 answer
Postgresql like
SQL
2 votes226 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL

Share