/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

3 votes229 views3 answers
Mysql auto increment after delete
SQL
0 vote196 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote200 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote148 views1 answer
Mysql convert column to uppercase
SQL
0 vote266 views1 answer
Oracle plsql sleep
SQL
1 vote198 views1 answer
Mysql decimal allow negative values?
SQL
0 vote207 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote256 views1 answer
How to rename a database in tsql
SQL
5 votes196 views1 answer
How to check nls format in oracle
SQL
6 votes241 views6 answers
Rename column postgres
SQL

Share