So now that I have the GMMK, I decided to see just how bad my old Logitech G710 keyboard was after five years of service. It… wasn’t pretty. Imagine five years of never once cleaning it in a four cat household, and never even doing the usual cotton swabs soaked in rubbing alcohol every few months. Well, imagine no further!
In the process of working on a customer migration and came up with a neat query for finding tables that don’t have a primary key:
SELECT c.oid::REGCLASS::TEXT AS table
FROM pg_class c
JOIN pg_namespace n ON (n.oid = c.relnamespace)
LEFT JOIN pg_constraint p ON (p.conrelid=c.oid AND p.contype = 'p')
WHERE c.relkind IN ('p', 'r')
AND n.nspname NOT IN ('pglogical', 'information_schema', 'bdr')
AND n.nspname NOT LIKE 'pg\_%'
AND p.conrelid IS NULL;
For anyone out there that is using pglogical, this is how you figure out if there are any tables that won’t work in the default replication set.