/SQL/Create duplicate table in postgresql

Create duplicate table in postgresql

Create duplicate table postgres

create table dupe_users as (select * from users);

-- The `with no data` here means structure only, no actual rows
create table dupe_users as (select * from users) with no data;

Source: popsql.com

Similar codes

1 vote63 views1 answer
How to delete a record from sqlite in android
SQL
7 votes81 views5 answers
Sql remove spaces
SQL
9 votes99 views6 answers
Oracle substring
SQL
1 vote107 views1 answer
Athena query timestamp greater than
SQL
0 vote84 views1 answer
A network or instance-specific error sql server
SQL
0 vote26 views1 answer
Mysql insert with foreign key
SQL
7 votes79 views2 answers
Create index mysql cli
SQL
-1 vote77 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote67 views1 answer
Drop all tables db2
SQL
4 votes143 views2 answers
Sql display today's date
SQL