"Sandy Spence" <axs@xxxxxxxxxx> 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
