/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

2 votes234 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
-1 vote235 views1 answer
How to dump .csv file into mysql
SQL
3 votes278 views1 answer
Oracle list invalid password logon denied
SQL
1 vote219 views1 answer
Psql connect to another database
SQL
21 votes229 views4 answers
Oracle add column
SQL
0 vote221 views1 answer
Sql server split string and insert into table select
SQL
6 votes250 views3 answers
Create database mysql utf8
SQL
4 votes225 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote247 views2 answers
Sql server backup table
SQL
0 vote233 views1 answer
Copy data from one postgres container to another
SQL

Share