/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

5 votes226 views1 answer
How to use rank function in sql
SQL
2 votes248 views2 answers
Mysql bidirectional composite primary key
SQL
1 vote226 views1 answer
How to between in sql
SQL
1 vote230 views1 answer
Oracle sql create view
SQL
1 vote239 views1 answer
OstgreSQL version
SQL
0 vote219 views1 answer
How to connect to mysql in ef 6
SQL
0 vote204 views1 answer
Metada in sql
SQL
3 votes322 views1 answer
How to get yesterday date in sql
SQL
0 vote217 views1 answer
Update sqlite
SQL
1 vote214 views1 answer
How to see all table partition in oracle
SQL