/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

2 votes282 views1 answer
Merge two columns in sql oracle
SQL
1 vote289 views1 answer
Events mysql
SQL
37 votes461 views3 answers
Sql check duplicate value in column
SQL
3 votes242 views1 answer
How to get list of synonyms in oracle
SQL
0 vote274 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote329 views1 answer
Sql int vs integer
SQL
2 votes273 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote277 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
17 votes289 views2 answers
Mysql date to string
SQL
0 vote333 views1 answer
Alternative for LIMIT sql
SQL