Today I had a small task that involved messing with a table that shouldn't be messed with. I discovered that there are two quick ways to duplicate a table on PostgreSQL:
-- copies everything to the `_bkp` table
CREATE TABLE table_bkp AS (SELECT * FROM original_table);
-- only copies the table structure
CREATE TABLE table_bkp AS (SELECT * FROM original_table) WITH NO DATA;