Re: Why dos select work when pg_dump fails? - Mailing list pgsql-admin

Darren Reed <darrenr+postgres@fastmail.net> writes:
> For whatever reason, I'm back dealing with corrupted tables but
> curiously while this fails:

> pg_dump -U postgres -a -t table -f /data/table.dump

> this works:

> psql -U postgres -A -o /data/table.dump -c "SELECT * FROM table;"

pg_dump is evidently failing while trying to get the definitions
of that table's indexes.  Does "\d table" work?

            regards, tom lane