Duplicating tables in PostgreSQL

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;

Articles from blogs I follow around the net

Trimming a Fake Object

A refactoring example. When I introduce the Fake Object testing pattern to people, a common concern is the maintenance burden of it. The point of the pattern is that you write some 'working' code only for test purposes. …

via ploeh blog November 20, 2023

Building a digital vigil for those we've lost

This post is hard to write in a lot of ways. It's more personal than most I've written. This is presumptively a tech blog, and this piece is about so much more than technology. But it's important. Making things, software or otherwise, is ultimatel…

via ntietz.com blog November 19, 2023

#122 Experimenting and Learning

Update on what happened across the GNOME project in the week from November 10 to November 17. GNOME Circle Apps and Libraries Workbench A sandbox to learn and prototype with GNOME technologies. Sonny says Workbench is a code playground and Library to learn, e…

via This Week in GNOME November 17, 2023

Generated by openring