/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

15 votes367 views7 answers
MYSQL
SQL
2 votes339 views2 answers
Set database timezone mysql
SQL
0 vote296 views1 answer
Check if due date is less than todays date sql
SQL
0 vote433 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote354 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
1 vote378 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
24 votes394 views6 answers
Alter table name sql
SQL
1 vote359 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
6 votes394 views3 answers
Create database mysql utf8
SQL
0 vote354 views1 answer
How to select only id where is not in column mysql
SQL