Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

How to Duplicate a Table in PostgreSQL

Sometimes it's useful to duplicate a table:

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;

Ready for a modern SQL editor?