/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 votes337 views3 answers
How to check current user in mySQL
SQL
1 vote322 views2 answers
Mysql extract number from string
SQL
6 votes282 views1 answer
Sqlite foreign key
SQL
8 votes300 views1 answer
Show mysql user table
SQL
0 vote311 views1 answer
Connect laravel to mysql on mac
SQL
-1 vote304 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote358 views1 answer
Mssql last day of month
SQL
2 votes295 views3 answers
Postgresql reset auto increment
SQL
0 vote306 views2 answers
Sqlalchemy core in clause
SQL
0 vote308 views1 answer
Openquery insert into linked server
SQL