/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

-1 vote273 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
2 votes266 views1 answer
Enum in SQL Server
SQL
5 votes293 views2 answers
Oracle find all tables with column name
SQL
0 vote262 views1 answer
Mql5 list all available symbols
SQL
0 vote268 views1 answer
Find most frequent value in SQL column
SQL
1 vote299 views1 answer
Mamp mysql path mac
SQL
0 vote287 views2 answers
Mysql where in maintain order group_concat
SQL
14 votes281 views1 answer
Sql value of string
SQL
3 votes262 views1 answer
Oracle undo tablespace list by user
SQL
0 vote294 views1 answer
Allow null in psql
SQL