/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 vote259 views1 answer
Add column in sql server ubuntu
SQL
0 vote267 views1 answer
Plsql find location of procedure
SQL
0 vote265 views1 answer
Psql attribute cannot login
SQL
0 vote268 views1 answer
Qt qsql check if table exist
SQL
0 vote253 views1 answer
Grant access on table in oracle
SQL
-1 vote283 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
1 vote271 views2 answers
Select into temp table
SQL
1 vote264 views1 answer
Mysql check table exists
SQL
1 vote259 views1 answer
Oracle case
SQL
4 votes263 views4 answers
Date less than in sql
SQL