/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

3 votes272 views1 answer
Define REGEXP?
SQL
0 vote252 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote259 views1 answer
Get who is hired in january in sql
SQL
0 vote264 views1 answer
Find invalid datetime field
SQL
17 votes253 views6 answers
Sql current date
SQL
0 vote249 views1 answer
Oracle list chain steps
SQL
0 vote278 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
1 vote273 views1 answer
Oracle schema size
SQL
0 vote271 views1 answer
Update database collation in postgresql
SQL
150 votes487 views10 answers
Grepper
SQL