/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

0 vote173 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote153 views1 answer
Select password from user mysql
SQL
0 vote153 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote155 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
17 votes162 views3 answers
Postgresql version command
SQL
0 vote140 views1 answer
Call procedure in wordpress
SQL
0 vote159 views1 answer
How to run mysql in git bash
SQL
1 vote167 views1 answer
Change table to innodb mysql
SQL
0 vote212 views1 answer
Oracle create package specification
SQL
3 votes147 views1 answer
Oracle revoke grant
SQL

Share