/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

2 votes340 views2 answers
Install postgresql
SQL
0 vote311 views1 answer
Oracle query to see what scema i am working in
SQL
6 votes382 views3 answers
Check if string contains substring sql
SQL
10 votes327 views3 answers
Sql check double value
SQL
1 vote317 views2 answers
Sql groub by count
SQL
0 vote292 views1 answer
Sqlite3 now
SQL
0 vote324 views1 answer
Azure sql server check foreign key
SQL
-1 vote355 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
-1 vote335 views3 answers
SQL MM/dd/yyyy format
SQL
-1 vote339 views3 answers
How to restart mysql in linux
SQL