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 ---------------------------(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