Andreas Schlegel <schlegelaw@gmx.de> writes:
> My question is: is there change to edit the the dump and remove the
> view? I tried to open it with vi. I can read a bit but not all.
You can do a selective restore by listing the dump's table of contents
into a file, editing the file, and then using it as a control file for
pg_restore. See the pg_restore man page.
regards, tom lane