/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

0 vote171 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote161 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote166 views1 answer
Get null value in sql
SQL
15 votes163 views2 answers
Open postgress in terminal mac
SQL
0 vote201 views1 answer
Alternative for LIMIT sql
SQL
6 votes185 views2 answers
What is non relational database
SQL
2 votes162 views1 answer
Sql ignore accents
SQL
0 vote161 views1 answer
What is SQL data store?
SQL
9 votes173 views1 answer
Mysql check date range
SQL
0 vote174 views1 answer
Oracle exchange partition
SQL