/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

10 votes260 views2 answers
Show tables in schema oracle
SQL
10 votes284 views4 answers
SELECT FROM WHERE
SQL
0 vote261 views1 answer
Datetime postgres typeorm
SQL
0 vote217 views1 answer
Create bakupd database sqlserver
SQL
0 vote270 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote252 views1 answer
Postgresql default value boolean
SQL
0 vote242 views1 answer
Delete insert record in sql server
SQL
11 votes260 views5 answers
How to install sqlite3 python
SQL
0 vote264 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote273 views1 answer
Mysql join column order By and group By
SQL