"Sandy Spence" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate