/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 vote174 views2 answers
Oracle replace
SQL
0 vote175 views1 answer
Get date from timestamp in mysql
SQL
1 vote247 views1 answer
Oracle previous year
SQL
18 votes248 views3 answers
Get the list of all tables in sql server
SQL
0 vote161 views2 answers
Mysql regexp match word
SQL
0 vote215 views1 answer
Count column of tables psql
SQL
4 votes168 views2 answers
How to delete row in sql
SQL
53 votes563 views6 answers
How to install mysql ubuntu
SQL
10 votes176 views4 answers
Primary key sql
SQL
0 vote164 views1 answer
Wordpress database query change url
SQL

Share