/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

0 vote280 views1 answer
Delete all rows from table sqlite
SQL
53 votes528 views6 answers
Sql server alter column
SQL
1 vote333 views1 answer
Hexadec to sql REDSHIFT
SQL
12 votes353 views4 answers
How to check mysql version ubuntu
SQL
3 votes331 views2 answers
Postgresql remove not null constraint
SQL
1 vote320 views5 answers
Sql 2nd highest salary
SQL
12 votes322 views4 answers
Mysql version
SQL
0 vote327 views1 answer
What is between keyword used for
SQL
1 vote337 views1 answer
Postgresql not in
SQL
0 vote344 views2 answers
While mysql
SQL