/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

1 vote141 views1 answer
Alter user mysql native password
SQL
7 votes204 views2 answers
Phpmyadmin change password
SQL
11 votes185 views2 answers
Turn off safe mode mysql
SQL
2 votes195 views1 answer
Set auto increment from 1
SQL
2 votes184 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote189 views1 answer
How to check event scheduler status mysql
SQL
0 vote195 views1 answer
To_date sql
SQL
1 vote181 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote178 views2 answers
How to type a blank discord messgae
SQL
13 votes214 views3 answers
Mysqldump structure only
SQL