/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

3 votes208 views1 answer
Oracle show trigger code
SQL
0 vote199 views1 answer
Sql alter table order by
SQL
0 vote188 views1 answer
Docker export psql sql
SQL
0 vote204 views1 answer
Execut sql python
SQL
1 vote199 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote206 views1 answer
Postgres killing connections on db
SQL
2 votes199 views1 answer
Scaffold npgsql net core
SQL
0 vote194 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote186 views1 answer
Mysql cdn link
SQL
1 vote180 views1 answer
Oracle user last connected
SQL