/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

2 votes215 views1 answer
Check isolation level in mysql
SQL
0 vote236 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote219 views1 answer
Sql convert datetime to year
SQL
1 vote259 views1 answer
UseSqlServer no definition
SQL
0 vote271 views1 answer
Mssql find deadlocks
SQL
0 vote218 views1 answer
Set default value now() date
SQL
4 votes220 views1 answer
Sql delete where in select
SQL
1 vote237 views1 answer
Influxdb export to csv
SQL
2 votes209 views1 answer
Node and mysql like
SQL
6 votes223 views1 answer
Phpmyadmin password root
SQL