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 vote139 views1 answer
Sql delete caracter list
SQL
0 vote110 views1 answer
How to reset AI in sql
SQL
0 vote130 views1 answer
Sql query for login with email or username
SQL
0 vote120 views1 answer
Display first three characters sql
SQL
0 vote145 views1 answer
Pl sql search in all packages
SQL
5 votes126 views1 answer
Oracle nls instance
SQL
8 votes124 views1 answer
Declare table variable sql server
SQL
1 vote115 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
3 votes110 views1 answer
APEX elapsed time
SQL
2 votes118 views1 answer
Set boolean flasksql
SQL