/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

9 votes348 views2 answers
Nosql databases
SQL
1 vote313 views1 answer
Install postgresql on raspberry pi
SQL
0 vote301 views1 answer
Sql cross apply vs join
SQL
0 vote256 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote324 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote332 views1 answer
Sql last 3 rows
SQL
0 vote302 views1 answer
Delete double on SQL with multiple primary keys
SQL
4 votes327 views3 answers
Rename table column postgresql
SQL
7 votes279 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote292 views1 answer
Strat with in sql
SQL