/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

16 votes219 views2 answers
Add column to all tables after first column mysql
SQL
0 vote189 views1 answer
Duplicate foreign key constraint name
SQL
0 vote216 views1 answer
Window function to forward fill
SQL
0 vote243 views1 answer
Get role postgres
SQL
-1 vote200 views1 answer
How to use update trigger in sql
SQL
0 vote208 views1 answer
Porcentaje sql
SQL
0 vote238 views1 answer
Full outer join in mariadb mysql
SQL
0 vote250 views3 answers
Select top 10 rows in sql
SQL
0 vote235 views1 answer
Dockerfile example for Django
SQL
0 vote213 views2 answers
Csv into data postgres
SQL