"Guo, Yun" <YGuo(at)cvent(dot)com> writes:
> Is there a way to repair the database if it's corrupted?
There's no evidence here that you've got any server-side corruption.
pg_dump should be getting back the exact same results you got
manually.
(BTW, I assume you've ruled out the possibility that pg_dump is connecting
to some other server or database than the one you're looking at
manually...)
regards, tom lane