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

0 vote132 views1 answer
Creating a simple notify in postgresql
SQL
0 vote120 views1 answer
How to fetch unique records from two tables
SQL
0 vote115 views1 answer
Mysql show category once count how many products
SQL
0 vote135 views1 answer
Count characters of string mysql
SQL
15 votes131 views3 answers
Find duplicate keys in mysql
SQL
0 vote118 views1 answer
Zerar auto increment mysql
SQL
0 vote121 views1 answer
Sql find leading space
SQL
0 vote120 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote146 views1 answer
Connecting mySQL to STS
SQL
0 vote137 views1 answer
How to alter length character varying postgres
SQL