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

1 vote134 views1 answer
Oracle update with sequence
SQL
0 vote137 views1 answer
How to find sql server name
SQL
-2 votes183 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote126 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote303 views1 answer
Power bi connect to postgresql
SQL
12 votes122 views4 answers
SQL Where
SQL
0 vote130 views1 answer
Psql select * from table
SQL
0 vote129 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote156 views1 answer
Plpgsql create function
SQL
0 vote133 views1 answer
How to put value in parameters in mysqldataadapter
SQL