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;
Shared queries and folders ✅ Version history ✅ One-click connection to PostgreSQL ✅
Get more done, together, with PopSQL and PostgreSQL
Previous