Re: information_schema.tables view does not exist

Lukasz Brodziak <lukasz.brodziak@gmail.com> writes:
> I got a database from client to be migrated from 8.2.4 to 9.0 and I got an
> error ERROR:  could not open relation 1663/206914/10780: No such file or
> directory.
> When I checked pg_class for the oid it occured to be
> information_schema.tables view. Is there anyway of restoring the view?

Um ... that's a view, so it's entirely expected that there would not be
any underlying file for it.

What exactly did you do to get that error message?

            regards, tom lane