/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 vote283 views2 answers
Mysql current user
SQL
0 vote298 views1 answer
Mysql aspas simples
SQL
0 vote301 views1 answer
How to delete duplicate rows in oracle
SQL
5 votes330 views1 answer
Mysql count lines
SQL
6 votes358 views3 answers
What is where in sql
SQL
9 votes309 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote295 views1 answer
Open postgresql.conf in centos
SQL
0 vote340 views1 answer
What is metadata in sql
SQL
1 vote271 views1 answer
How to see all table partition in oracle
SQL
0 vote301 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL