Does ALTER TABLE/RENAME code help you? You can rename sequences with that...
Hmm, that doesn't cover pg_attrdef.adbin. I think the best way is to create the default expressions from scratch, as Tom already mentioned.
-- Bernd ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings