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 vote172 views1 answer
Postgres call view
SQL
0 vote178 views1 answer
What is SQL data store?
SQL
2 votes217 views3 answers
Current setting postgres timezone
SQL
3 votes182 views1 answer
Two select sql
SQL
0 vote186 views1 answer
SqlFunction does not exist
SQL
0 vote182 views1 answer
Not between mysql
SQL
0 vote195 views1 answer
Kotlin sqlite delete row
SQL
0 vote174 views1 answer
Mysql undo delete
SQL
0 vote179 views1 answer
Change role postgres
SQL
6 votes242 views3 answers
Rename column ORACLE
SQL