/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 votes226 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
2 votes175 views1 answer
Oracle number to percentage
SQL
0 vote186 views1 answer
Default value false mysql
SQL
6 votes178 views3 answers
Can you update NULL in sql
SQL
0 vote182 views1 answer
Mysql to get column name in database
SQL
0 vote213 views1 answer
How to find date from date table in sql
SQL
0 vote182 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote176 views1 answer
Inserted row count tsql
SQL
0 vote175 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote180 views2 answers
Postgresql remote connect
SQL

Share