/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

7 votes119 views5 answers
Oracle alter table
SQL
0 vote118 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote177 views1 answer
Sql and
SQL
1 vote119 views1 answer
How to see all table partition in oracle
SQL
0 vote99 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote129 views1 answer
Oracle transaction rollback not working
SQL
0 vote129 views1 answer
Oracle insert single quote in string
SQL
0 vote123 views1 answer
Sql #region
SQL
1 vote117 views1 answer
Increase existing date in sql oracle
SQL
0 vote117 views1 answer
Postgresql delete type
SQL