/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 vote300 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote243 views1 answer
Sql delete caracter list
SQL
0 vote248 views1 answer
How to create a table based on another table in mysql
SQL
0 vote301 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote249 views1 answer
Can we rollback in sql
SQL
0 vote228 views1 answer
How to use query in nosql
SQL
0 vote263 views1 answer
Cannot pip install mysqlclient
SQL
0 vote237 views1 answer
Mysql grant access to one database
SQL
0 vote233 views1 answer
Check sql database table lock
SQL
1 vote239 views1 answer
Postgresql reset serial counter after deleting content
SQL