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 votes167 views1 answer
Set column to not null mysql
SQL
0 vote181 views1 answer
Mysql join column order By and group By
SQL
0 vote164 views1 answer
Export partttion and import in oracle
SQL
20 votes173 views1 answer
Sql change column types
SQL
10 votes163 views5 answers
Mysql create user
SQL
0 vote174 views1 answer
Sql select column names starting with
SQL
2 votes194 views1 answer
Import large .sql files into lampp
SQL
0 vote164 views1 answer
Mysql select all table that have field names
SQL
2 votes166 views1 answer
Import database in mysql command line xampp
SQL
1 vote171 views1 answer
Give a column name to values generated from case statement in sql
SQL