"Sandy Spence" <axs(at)aber(dot)ac(dot)uk> writes:
> thanks for the help, one last question I hope, how do I cross reference the
> pg_class, pg_user and pg_type so that I can obtain the usesysid of the
> missing owner?
It's whatever is in the relowner and typowner fields. There is no entry
anymore in pg_user, if there were you wouldn't be having a problem;
so you'll likely have to make up names for the user ids.
regards, tom lane