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 vote173 views1 answer
Sql server sleep
SQL
0 vote136 views1 answer
Sql random decimal
SQL
0 vote146 views1 answer
Mysql 5.7 in centos 7
SQL
16 votes145 views1 answer
Sqlserver add column to table
SQL
0 vote150 views1 answer
Heidisql check how much space a row
SQL
0 vote166 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
2 votes156 views1 answer
Sql server check for value in multiple columns
SQL
0 vote148 views1 answer
Mod in sql
SQL
0 vote144 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote158 views1 answer
Sql query to find duplicate email address
SQL