Darren Reed <darrenr+postgres@xxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
