/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 vote271 views1 answer
Get number of rows in every table mysql
SQL
0 vote284 views1 answer
Timestamp(0) postgresql
SQL
0 vote279 views1 answer
Select top values sql
SQL
79 votes496 views6 answers
Grepper code
SQL
0 vote269 views1 answer
SQL Server Enterprise
SQL
22 votes264 views4 answers
Tsql rename table
SQL
0 vote285 views1 answer
Search from comma separated values in sql server
SQL
0 vote262 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote249 views1 answer
Oracle list chain steps
SQL
15 votes297 views3 answers
Mysql update add to existing value
SQL