/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

15 votes256 views2 answers
How to drop database name in postgresql
SQL
12 votes263 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote292 views1 answer
Get only one row in mysql
SQL
0 vote273 views1 answer
Mysql Like(searching in the string)
SQL
0 vote267 views1 answer
T-sql check if data exists
SQL
1 vote265 views2 answers
Mysql: command not found
SQL
0 vote299 views1 answer
Sql query wordpress export post
SQL
61 votes433 views6 answers
Mysql add column
SQL
1 vote277 views1 answer
Oracle turn off constraint
SQL
1 vote287 views1 answer
Where date = max(date) in sql
SQL