/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

25 votes179 views6 answers
Modify column name in mysql
SQL
2 votes179 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
5 votes212 views4 answers
Traduction
SQL
2 votes179 views4 answers
Duplicate record mysql
SQL
0 vote177 views1 answer
How to check if there is no database schema
SQL
-2 votes287 views1 answer
How-to-remove-mysql-root-password
SQL
3 votes220 views5 answers
Duplicate table sql
SQL
5 votes192 views1 answer
Oracle find foreign key dependencies
SQL
1 vote217 views1 answer
Epoch time converter in snowflake
SQL
6 votes184 views3 answers
Can you update NULL in sql
SQL

Share