I've written a small script that allows me to dump the old MySQL tables into a PostgreSQL database, prepending their name with oldapp_* We are starting to write some data migration scripts which ...

Can you do a foreign key within a single table, though? I've only ever seen foreign key constraints tying a field in one table to a field in another table.