/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 vote328 views1 answer
Change table to innodb mysql
SQL
0 vote344 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
1 vote356 views1 answer
Oracle datafile max size 32gb
SQL
1 vote357 views1 answer
Sql headers delphi
SQL
3 votes347 views1 answer
DB: in eloquent using sql
SQL
7 votes344 views2 answers
Execute mysql file
SQL
0 vote368 views1 answer
Querry mysql by 2 columns
SQL
0 vote427 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote345 views1 answer
Query params sql insert python f string
SQL
0 vote331 views1 answer
Export partttion and import in oracle
SQL