/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

0 vote341 views1 answer
Mysql could not fetch tables
SQL
0 vote343 views1 answer
Odd record sql query
SQL
2 votes333 views1 answer
Drop table if exists in postgres
SQL
0 vote339 views1 answer
What is the difference between now() and current_date()?
SQL
-1 vote362 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote345 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
1 vote361 views1 answer
Sql server list locks
SQL
36 votes359 views3 answers
Finding duplicate column values in table with sql
SQL
-1 vote362 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
1 vote347 views1 answer
How do you use sql in you company
SQL